Oracle
1Z0-144 · Question #103
Which two statements are true about the instead of triggers? (Choose two.)
The correct answer is C. The instead of triggers can be written only for views, and the before and after timing options are D. The check option for views is not enforced when Insertions or updates to the view are performed. B is not correct because you can do dml on some views.
Creating Triggers
Question
Which two statements are true about the instead of triggers? (Choose two.)
Options
- ADelete operations cannot be performed using the instead of triggers.
- BThe instead or triggers must be created to add or modify data through any view.
- CThe instead of triggers can be written only for views, and the before and after timing options are
- DThe check option for views is not enforced when Insertions or updates to the view are performed
How the community answered
(46 responses)- A15% (7)
- B9% (4)
- C76% (35)
Explanation
B is not correct because you can do dml on some views.
Topics
#INSTEAD OF triggers#view triggers#check option#DML on views
Community Discussion
No community discussion yet for this question.