Multiple choice technology databases

Which of the following actions will NOT cause a trigger to be fired?

  1. ALTER

  2. INSERT

  3. DELETE

  4. UPDATE
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Database triggers are specifically designed to respond to Data Manipulation Language (DML) operations that modify data: INSERT, UPDATE, and DELETE. These operations represent actual data changes that might require automatic business logic execution. ALTER is a Data Definition Language (DDL) operation that modifies table structure (like adding columns, changing constraints) rather than the data itself. DDL operations do not fire triggers because triggers are meant to respond to data content changes, not structural changes. This separation maintains clear boundaries between data modification and structural modification.

Keep practicing — related questions