PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
TRIG_A

B.
TRIG_B

C.
TRIG_C

D.
TRIG_D

2 Comments on “which trigger will be activated first?

  1. Chow, Kenneth KY says:

    Triggers and typed tables: A BEFORE or AFTER trigger can be attached to a typed table at any level of a table hierarchy. If an SQL statement activates multiple triggers, the triggers will be executed in their creation order, even if they are attached to different tables in the typed table hierarchy.




    0



    0

Leave a Reply