Multiple choice technology databases

The following trigger exists: create trigger trig on t for insert, update, delete as begin print 'This is 'trig' ' end The following command is now executed: create trigger trig on t for insert as begin print 'This is 'trig' ' end After executing this command, for which DML actions on table 't' will a trigger be fired?

  1. insert

  2. update

  3. insert, update, delete

  4. delete,update
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Creating a trigger with an existing name on the same table replaces its definition in database systems like Sybase ASE. Because the second command specifies only for insert, it overwrites the original multi-action trigger, leaving a trigger that only fires on insert operations.

Keep practicing — related questions