Multiple choice technology databases

You want to make changes in another database object whenever any new database object is created. which of the following triggers will you use?

  1. DML Trigger

  2. Instead of Trigger

  3. DDL Trigger

  4. Nested Trigger
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DDL (Data Definition Language) triggers fire when CREATE, ALTER, DROP, GRANT, DENY, REVOKE, or sp_rename statements are executed on database objects. DML triggers respond to INSERT, UPDATE, DELETE operations on data. INSTEAD OF triggers replace the triggering action. Nested triggers refer to trigger chains, not a specific type.

Keep practicing — related questions