What does a DBMS do to break a deadlock?
A) rolls back all transactions involved in the deadlock
B) chooses one deadlocked user to be the victim
C) closes the database and restores from the last backup
D) erases the records involved in the deadlock and reschedules the transactions

Question

Quizplus · Accepted Answer

A DBMS breaks a deadlock by selecting one of the deadlocked transactions as the victim and aborting it. This frees up the resources held by that transaction and allows the other transactions to proceed. Rolling back all transactions involved in the deadlock or erasing the records involved in the deadlock would cause data loss and closing the database and restoring from the last backup would result in significant downtime. Therefore, choosing a victim transaction is the best way to resolve a deadlock.

What Does a DBMS Do to Break a Deadlock