Answer to Question #214303 in Databases | SQL | Oracle | MS Access for Hassam

Question

Read information from following table carefully and check whether the following schedule contains a deadlock or not by constructing wait for graph?       

A schedule S= {T₁, T₂, T₃, T₄, T₅, T₆, T₇, T₈} is shown with following information.

Transactions Holding Locks

Transaction waiting for Locks

Data item on which lock is required

T_2------T₁---A

T_8----T_3------B

T_3-----T_4------C

T_4----T_7------D

T_5----T_2-----X

T_6----T_8----Y

T_3----T_6----Z

Answer 1

The above schedule contain a deadlock. This is because T3 is waiting for T8, T8 is waiting for T6 and T6 is waiting for T3 hence they will not come out of this loop.