Oracle Database 11g: Program with PL/SQL — Question 17

Which two statements are true about the instead of triggers? (Choose two.)

Answer options

• 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 triggers.

Correct answer: C, D

Explanation

Option C is correct because instead of triggers are specifically designed for views and do not support before and after timing. Option D is also correct as the check option does not apply when modifications to the view are made using instead of triggers. Options A and B are incorrect as they misrepresent the capabilities and requirements of instead of triggers.