Which of the following database objects can be used to raise an error if a table is updated?() A.PackageB.TriggerC.Stored ProcedureD.Informational Constraint
Which of the following database objects can be used to raise an error if a table is updated?()
A.Package
B.Trigger
C.Stored Procedure
D.Informational Constraint
相关考题：
从供选择的答案中选出应填入英语文句中()的正确的答案。Applications put computers to practical business (A), but below the (B) it's the heart of an operating system the kernel that provides the technical wizardry to juggle multiple program, connect to networks and store (C) .A traditional kernel provides all the functions for applications. The kernel (D) memory, I/O devices and parcels out processor time.The kernel also supports security and fault (E), which is the ability to recover automatically when parts of the system fail.A: ① used ② use ③ apply ④ appliedB: ① earth ② bottom ③ table ④ surfaceC: ① graphics ② data ③ text ④ imageD: ① manages ② manage ③ managed ④ managingE: ① error ② question ③ tolerance ④ problem
You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following
YourapplicationmustaccessdatathatislocatedontwoSQLServer2005computers.OneoftheseserversisnamedSQL1andtheotherisSQL2.YouhavepermissionstocreateastoredprocedureonSQL1tosupportyourapplication.However，onSQL2youonlyhavepermissionstoselectdata.YouwritethestoredprocedureonSQL1.ThestoredprocedureaccessesSQL2byusingtheOPENQUERYTransact-SQLstatement.However,thequeryfailswhenexecuted.Youneedtotroubleshootthecauseoftheerror.Whatshouldyoudo？（）A.Jointhetwoserversbyusingthefour-partsyntaxofserver.database.schema.table.B.ReferenceSQL2byusinganalias.C.AddSQL2asaremoteservertoSQL1.D.AddSQL2asalinkedservertoSQL1.
IfyouaregoingtorunaTSPITRrecovery,whichviewwillhelpyoutodeterminewhichobjectswillbelostduringtheTSPITR?() A.TS_OBJECTS_TO_BE_DROPPEDB.TS_PTTR_OBJECT_DROPPEDC.TS_PITR_OBJECTS_TO_BE_DROPPEDD.TS_OBJECTS_DROPPEDE.TS_DROPPED_OBJECTS
A MySQL replication slave is set up as follows: User all InnoDB tablesReceives ROW-based binary logs Has the read-only optionThe replication slave has been found in an error state.You check the MySQL error log file and find the following entries:2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 10622013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’Error_code: 10622013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix theproblem, and restart the slave SQL thread with SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?（）A.The slave was created with mysqldump –u root –p – skip-lock-table—all-databases /data/data.sqlB.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows functionC.For tables with UNIQUE keys, statement-based replication must be used maintain integrityD.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewriteE.The applications have the SUPER privilege, which allows them to update rows
ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1;Can‘t find record in ‘t1‘, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event‘s master log 56_master-bin. 000003, end_log_pos 851, Error_code: 10322013-08-27 14:15:47 9056 [warning] Slave: Can‘t find record in ‘t1‘ Error_code: 10322013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START.We stopped at log ‘56_masterbin. 000003‘ position 684 Why did you receive this error?（）A.The slave SQL thread does not have DELETE privileges to execute on test.t1 table.sB.The table definition on the slave -litters from the masterC.Multi-threaded replication slaves can have temporary errors occurring for cross database updatesD.The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
Which of the following actions are stated in the correct order prior to loading or discharging cargo on a Ro-Ro vessel?A.Lower the stern ramp，raise/open the stern door，turn on ventilation for cargo holdsB.Turn on ventilation for cargo holds，raise/open the stern door，lower the stern rampC.Turn on ventilation for cargo holds，lower the stern ramp，raise/open the stern doorD.Raise/open the stern door，lower the stern ramp，turn on ventilation for cargo holds
以下那一个选项是查询数据方法：A．User.objects.filter(username='wangwu').get(pk=1)B．User.objects.filter(id=user_id).update(password='9999')C．User.objects.all().delete()D．User.objects.get(pk=user_id).delete()
以下那一个选项不是数据插入方法：A．ModelName.objects.create(参数=字典类型数据)B．ModelName.objects.get(列表或元组)C．ModelName.objects.update_or_create(参数=字典类型数据)D．ModelName.objects.bulk_create(列表或元组)