Multiple choice technology databases

We can write triggers for Truncate.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

TRUNCATE TABLE is a minimally logged operation that cannot fire triggers. Unlike DELETE statements which activate row-level triggers, TRUNCATE deallocates data pages without logging individual row deletions, bypassing trigger execution entirely. If you need trigger behavior, use DELETE instead. TRUNCATE is faster but less flexible.

Keep practicing — related questions