Oracle Database: Advanced PL/SQL — Question 52

In which type of trigger can :OLD and :NEW identifiers be used?

Answer options

• A. ROW
• B. AFTER SUSPEND
• C. AFTER STATEMENT
• D. BEFORE STATEMENT

Correct answer: A

Explanation

:OLD and :NEW identifiers are used in ROW-level triggers to access the values of the row before and after the triggering event. The other options, AFTER SUSPEND, AFTER STATEMENT, and BEFORE STATEMENT, do not support these identifiers as they operate at different levels where row-specific data isn't relevant.