Question 570
A database captures a record of critical status changes, including changes made outside the primary application. Initial testing shows: One multirow update creates accurate audit entries with no missing affected row. Which limitation should the team still consider?
Explanation
Correct Answer
Trigger failures can roll back business transactions and reduce throughput. A DML trigger can react to supported table changes using inserted/deleted virtual tables. Add a set-based trigger with narrow immutable audit writes only if approved.
Incorrect Answers
One UPDATE may affect many rows; inserted/deleted contain sets. Scalar assumptions lead to missing audit records.
A mentioned column may retain its old value. Compare inserted/deleted with NULL-aware semantics for actual transitions.
DML trigger work executes in the statement transaction; failures can roll back the business write or add latency.