niusouti.com

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

相似考题

1.DAO模型中，主要的控制对象有：DBEngine、Wordspace、Database、 RecordSet、______、QueryDef和Error。

2.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

3.YourapplicationmustaccessdatathatislocatedontwoSQLServer2005computers.OneoftheseserversisnamedSQL1andtheotherisSQL2.YouhavepermissionstocreateastoredprocedureonSQL1tosupportyourapplication.However，onSQL2youonlyhavepermissionstoselectdata.YouwritethestoredprocedureonSQL1.ThestoredprocedureaccessesSQL2byusingtheOPENQUERYTransact-SQLstatement.However,thequeryfailswhenexecuted.Youneedtotroubleshootthecauseoftheerror.Whatshouldyoudo？（）A.Jointhetwoserversbyusingthefour-partsyntaxofserver.database.schema.table.B.ReferenceSQL2byusinganalias.C.AddSQL2asaremoteservertoSQL1.D.AddSQL2asalinkedservertoSQL1.

4.从供选择的答案中选出应填入英语文句中()的正确的答案。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

更多“Which of the following database objects can be used to raise an error if a table is updated?() ”相关问题

  • 第1题：

    IfyouaregoingtorunaTSPITRrecovery,whichviewwillhelpyoutodeterminewhichobjectswillbelostduringtheTSPITR?()

    A.TS_OBJECTS_TO_BE_DROPPED

    B.TS_PTTR_OBJECT_DROPPED

    C.TS_PITR_OBJECTS_TO_BE_DROPPED

    D.TS_OBJECTS_DROPPED

    E.TS_DROPPED_OBJECTS


    参考答案：C

  • 第2题：

    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.s

    B.The table definition on the slave -litters from the master

    C.Multi-threaded replication slaves can have temporary errors occurring for cross database updates

    D.The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist


    参考答案：D

  • 第3题：

    以下那一个选项是查询数据方法：

    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()


    query()

  • 第4题：

    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.sql

    B.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function

    C.For tables with UNIQUE keys, statement-based replication must be used maintain integrity

    D.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite

    E.The applications have the SUPER privilege, which allows them to update rows


    参考答案：A, E

  • 第5题：

    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 holds

    B.Turn on ventilation for cargo holds，raise/open the stern door，lower the stern ramp

    C.Turn on ventilation for cargo holds，lower the stern ramp，raise/open the stern door

    D.Raise/open the stern door，lower the stern ramp，turn on ventilation for cargo holds


    正确答案：A

  • 第6题：

    以下那一个选项不是数据插入方法：

    A．ModelName.objects.create(参数=字典类型数据)

    B．ModelName.objects.get(列表或元组)

    C．ModelName.objects.update_or_create(参数=字典类型数据)

    D．ModelName.objects.bulk_create(列表或元组)


    手写

相关内容