Question 930
A database captures a record of critical status changes, including changes made outside the primary application. The team proposes this approach: Add a set-based trigger with narrow immutable audit writes only if approved. Which technical principle supports this approach?
Explanation
Correct Answer
A DML trigger can react to supported table changes using inserted/deleted virtual tables. Trigger failures can roll back business transactions and reduce throughput.
Incorrect Answers
SQL DML triggers execute per statement; inserted and deleted can contain many rows. Use set-based operations.
UPDATE(status) checks whether the column was targeted, not whether values changed. Compare inserted/deleted.
Synchronous trigger code shares transaction effects. Network failure can delay or roll back a status update.