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 is a logical unit of work that must either complete entirely (COMMIT) or be completely undone (ROLLBACK). These are the only two ways a transaction can terminate - partial completion is not allowed in ACID-compliant databases.