IBM Exam Questions

which trigger will be activated first?

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 SET billing_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