Question details

5138 Final Exam week 11
$ 15.00

Deadlock Avoidance
The transaction must obtain all the locks it needs before it can be executed. This technique avoids
rollback of conflicting transactions by requiring that locks be obtained in succession. However, the
serial lock assignment required in deadlock avoidance increases the response times.Deadlock Prevention
A transaction requesting a new lock is aborted if there is a possibility that a deadlock may occur. If
the transaction is aborted, all the changes made by this transaction are rolled back and all locks are
released. The transaction is then re-scheduled for execution. Deadlock prevention works because it
avoids the conditions that lead to deadlocking. 

Available solutions