Multiple choice technology databases

Which is valid in creating DML triggers ?

  1. DURING

  2. INSTEAD

  3. ON SHUTDOWN

  4. BEFORE
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DML triggers use timing keywords BEFORE, AFTER, and INSTEAD OF (for views). DURING is not valid SQL syntax. ON SHUTDOWN is a system event trigger, not DML. INSTEAD without OF is incomplete.

Keep practicing — related questions