Which two statements are true about the instead of triggers? (Choose two.)
A. Delete operations cannot be performed using the instead of triggers.
B. The instead or triggers must be created to add or modify data through any view.
C. The instead of triggers can be written only for views, and the before and after timing options are not valid.
D. The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of trigger.
Agree that correct answers are C,D.
Providing the quote from the reference:
https://docs.oracle.com/cd/B14117_01/appdev.101/b10795/adfns_tr.htm
“The INSTEAD OF option can only be used for triggers created over views.
The BEFORE and AFTER options cannot be used for triggers created over views.
The CHECK option for views is not enforced when inserts or updates to the view are done using INSTEAD OF triggers. The INSTEAD OF trigger body must enforce the check.”
A incorrect: can..
B incorrect: simpe view (from one table) no need trigger