Multiple choice technology databases

Two or more transactions in a simultaneous wait state, each waiting for other to release before it can proceed, is called

  1. Lost Update

  2. uncommitted dependency

  3. infinite loop

  4. Deadlock

  5. With hold
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Deadlock is a situation where two or more transactions are stuck waiting for each other to release locks, creating a circular dependency that prevents any transaction from proceeding. The other options are different concurrency issues: lost update occurs when one transaction overwrites uncommitted changes, uncommitted dependency involves reading uncommitted data, and infinite loop is a programming error unrelated to database locking.

Keep practicing — related questions