Multiple choice technology databases

A Transaction ends

  1. Only when it is Committed

  2. Only when it is Rolled back

  3. When it is Committed or Rolled back

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

A transaction in a database management system terminates either when it is explicitly committed (making changes permanent) or when it is rolled back (undoing all changes). These are the two standard ways to end a transaction. Simply executing DML statements doesn't end a transaction - the database waits for an explicit COMMIT or ROLLBACK command.

Keep practicing — related questions