Intermediate
Database Management Systems
Q55 / 100
What is a deadlock in a database context?
Correct! Well done.
Incorrect.
The correct answer is B) Two or more transactions each holding locks needed by the other, causing mutual blocking and requiring the DBMS to abort one
B
Correct Answer
Two or more transactions each holding locks needed by the other, causing mutual blocking and requiring the DBMS to abort one
Explanation
Database deadlocks: TXN A holds lock on row 1, wants row 2; TXN B holds lock on row 2, wants row 1. DBMS detects the cycle and kills one transaction (the "victim").
Progress
55/100