Which of the following is NOT a trigger type supported by Oracle Database?

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:

  • Oracle supports various trigger timings and event scopes.
  • Choices include BEFORE, AFTER, INSTEAD OF, and a distractor.


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

No comments yet. Be the first to comment!
Join Discussion