You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.
Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)
A. It should be an after trigger.
B. It should be a before trigger.
C. It should be a row-level trigger.
D. It should be a statement-level trigger.
E. It can be a before or an after trigger.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
I agree that correct answers are A,D.
Row level trigger you will cause ORA-04091 mutating table error
A row level trigger can not read or write from the table on which it has been fired.