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