Oracle
1Z0-144 · Question #52
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…
The correct answer is A. It should be an after trigger. D. It should be a statement-level trigger. See the full explanation below for the reasoning.
Question
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.)
Options
- AIt should be an after trigger.
- BIt should be a before trigger.
- CIt should be a row-level trigger.
- DIt should be a statement-level trigger.
- EIt can be a before or an after trigger.
How the community answered
(25 responses)- A80% (20)
- B4% (1)
- C12% (3)
- E4% (1)
Community Discussion
No community discussion yet for this question.