Multiple choice technology databases

Which of the following is the transaction control that prevents more than one user from updating data in a table?

  1. Commits

  2. Locks

  3. Savepoints

  4. Rollbacks
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Locks are the transaction control mechanism that prevents concurrent updates - they 'lock' data so only one transaction can modify it at a time. Commits finalize changes, savepoints mark rollback points, and rollbacks undo changes - none prevent concurrent access like locks do.

AI explanation

A lock is the transaction control mechanism that restricts other users from modifying (or sometimes reading) a row or table while one transaction holds it, preventing concurrent conflicting updates. Commits finalize a transaction's changes, savepoints mark rollback points within a transaction, and rollbacks undo changes — none of these actively block other users from updating data the way a lock does.

Keep practicing — related questions