Multiple choice technology databases

Identify the BOOLEAN variables in the context of the TRIGGER. Choose all that apply.

  1. UPDATING

  2. CREATING

  3. DELETING

  4. SELECTING

  5. INSERTING

  6. ALTERING
Reveal answer Fill a bubble to check yourself
A,C,E Correct answer
Explanation

PL/SQL provides three boolean predicates for trigger context: INSERTING (true if trigger fired due to INSERT), UPDATING (true if due to UPDATE), and DELETING (true if due to DELETE). These help write logic that behaves differently based on the triggering event. CREATING, SELECTING, and ALTERING are NOT valid PL/SQL boolean trigger variables.

Keep practicing — related questions