Advanced
SQL
Q82 / 100
What is a "deadlock" in a database, and how do most database systems handle it?
Correct! Well done.
Incorrect.
The correct answer is B) A deadlock occurs when two or more transactions each hold locks the others need, forming a cycle of dependencies; most databases detect this and abort (roll back) one of the transactions to break the cycle
B
Correct Answer
A deadlock occurs when two or more transactions each hold locks the others need, forming a cycle of dependencies; most databases detect this and abort (roll back) one of the transactions to break the cycle
Explanation
A deadlock is a circular wait condition between transactions holding conflicting locks; database engines typically run a deadlock detector that picks a "victim" transaction to roll back, allowing the others to proceed.
Progress
82/100