Multiple choice technology databases

Can you change the inserted value in one of the columns in AFTER insert trigger code?

  1. Yes

  2. No

  3. Can't Say

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In AFTER triggers, the insert operation has already completed and the data is written to the table. The inserted values cannot be modified because the transaction is past the point where changes are allowed. To modify inserted values, you would need an INSTEAD OF trigger or modify the data before insertion using a BEFORE trigger (in databases that support it). AFTER triggers are for post-insert operations like auditing or cascading changes.

Keep practicing — related questions