Which two does the INSTEAD OF clause in a trigger identify? (Choose two)
A.
The view associated with the trigger.
B.
The table associated with the trigger.
C.
The event associated with the trigger.
D.
The package associated with the trigger.
E.
The statement level or for each row association to the trigger.
Explanation:
Answer A is correct. You must specify the View. INSTEAD OF TRIGGERS are created on views
to allow DML statements on an on-updateable view.
Answer C is correct. An INSETED OF Trigger can fire for all three Triggering Events (INSERT,
UPDATE and UPDATE).
Answer B is incorrect INSTEAD of Triggers can only be created for Views they can’t be created on Tables.
Answer D is incorrect. You can’t call a package.
Answer E is incorrect. INSTEAD OF TRIGGERS must always fire FOR EACH ROW;
STATEMENT Level Triggers are not valid for Views