The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SE

题目

The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?（）

A.TRIG_A

B.TRIG_B

C.TRIG_C

D.TRIG_D

相似考题

1._______________[A] introduce[B] summon[C] trigger[D] create

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

3.“The Fighter on the Special Front”, a new－produced feature film, will be ________ in the college auditorium at seven tonight.A.showedB.showingC.showD.shown

4.A: Where()you last week? B: I()in Alabama.A、were/wereB、was/isC、were/wasD、was/were

参考答案和解析
参考答案：A
更多“The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_ ”相关问题

  • 第1题：

    You have table ‘apps‘,‘userdata‘ on server that uses MyISAM storage engine.You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands:Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p appsShell＞ mysql –u root –p –h server –e ‘ALTER TABLE ‘apps‘,‘userdata‘ ENGINE=InnoDB;‘Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p appsWhat effect does the – order-by-primary argument have on the mysqldump command?（）

    A.It exports tables with the most indexes first to assist with import speeds

    B.It ensures that unique indexes have no conflicts when the data is dumped

    C.It orders by primary key to assist in speeding up importing to InnoDB tables

    D.It must be specified so index data is dumped correctly when –on-create-info is used


    参考答案：C

  • 第2题：

    STM32F103外部中断的触发方式有：

    A．EXTI_Trigger_Rising

    B．EXTI_Trigger_Falling

    C．EXTI_Trigger_Rising_Falling

    D．以上都是


    以上都是

  • 第3题：

    数据库对象是数据库的组成部分，常用的数据库对象有表（Table）、索引（Index）、视图（View）、图表（Diagram）、用户（User）、（）等。

    A．默认值（Default）

    B．规则（Rule）

    C．触发器（Trigger）

    D．存储过程（Stored Procedure）


    表

  • 第4题：

    Attitudes to mental illness have shifted in recent years.

    A:displayed
    B:shown.
    C:changed
    D:demonstrated

    答案：C
    解析：

  • 第5题：

    【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）

    A．Create_Table，Alter_Table，Drop_Table

    B．Create_View，Alter_View，Drop_View

    C．Create_Procedure，Alter_Procedure，Drop_Procedure

    D．Rollback


    Rollback

  • 第6题：

    如果要让某个用户能够在所有模式下建表应该授予此用户哪个权限？

    A．create table

    B．create any table

    C．create all table

    D．create * table


    create any table

相关内容