Difficulty: Easy
Correct Answer: DURING
Explanation:
Introduction / Context:Triggers in Oracle can fire before or after DML events and, for views, Oracle supports INSTEAD OF triggers. Recognizing valid trigger timing keywords is fundamental for database programming.
Given Data / Assumptions:
Concept / Approach:Oracle valid timing keywords are BEFORE and AFTER for tables, and INSTEAD OF for views. There is no DURING timing in Oracle trigger syntax.
Step-by-Step Solution:
List valid keywords: BEFORE, AFTER, INSTEAD OF.Compare with options. DURING does not exist.Select DURING as the incorrect (unsupported) option.Verification / Alternative check:Oracle SQL Language Reference documents only BEFORE, AFTER, and INSTEAD OF timings for triggers.
Why Other Options Are Wrong:BEFORE is a standard trigger timing. AFTER is also standard. INSTEAD OF is used on views to substitute DML behavior.
Common Pitfalls:Assuming a natural-language timing like DURING exists; Oracle requires precise keywords.
Final Answer:DURING
Discussion & Comments