Multiple choice technology databases

Which statement does not fire the Trigger?

  1. Delete

  2. Truncate

  3. Insert

  4. Update
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

TRUNCATE is a DDL (Data Definition Language) operation that bypasses the transaction log and does not fire triggers. DELETE, INSERT, and UPDATE are DML (Data Manipulation Language) operations that respect triggers. This is why TRUNCATE is faster but also riskier - you cannot roll it back or trigger cleanup logic.

AI explanation

To answer this question, we need to understand what a trigger is and how it works in a database.

A trigger is a stored procedure that automatically executes when a specific event occurs in a database. These events can include inserting, updating, or deleting records in a table. Triggers are commonly used to enforce data integrity rules, perform calculations or validations, or log changes made to the database.

Now let's go through each option to determine which statement does not fire the trigger:

A) Delete: When a record is deleted from a table, it triggers the "delete" event, and any associated triggers will be fired. Therefore, option A can fire the trigger.

B) Truncate: When a table is truncated, all the records in that table are deleted. However, the truncate operation does not fire any triggers associated with the table. Therefore, option B does not fire the trigger.

C) Insert: When a new record is inserted into a table, it triggers the "insert" event, and any associated triggers will be fired. Therefore, option C can fire the trigger.

D) Update: When an existing record is updated in a table, it triggers the "update" event, and any associated triggers will be fired. Therefore, option D can fire the trigger.

Based on the explanations above, the correct answer is B) Truncate. This option does not fire the trigger associated with the table being truncated.

Keep practicing — related questions