Multiple choice technology databases

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ?

  1. Yes

  2. No

  3. 1 & 2

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

Triggers execute within the transaction that fired them. They cannot issue independent COMMIT or ROLLBACK - these are controlled by the calling transaction context. Doing so would break atomicity.

Keep practicing — related questions