GATEverse
← GATE CSE 2017 Set 1

Q42

MCQ2 marks, −0.67

In a database system, unique timestamps are assigned to each transaction using Lamport's logical clock. Let TS(T1)TS(T_{1}) and TS(T2)TS(T_{2}) be the timestamps of transactions T1T_{1} and T2T_{2} respectively. Besides, T1T_{1} holds a lock on the resource R,R, and T2T_{2} has requested a conflicting lock on the same resource R.R. The following algorithm is used to prevent deadlocks in the database system assuming that a killed transaction is restarted with the same timestamp. if TS(T2)<TS(T1)TS(T_{2})<TS(T_{1}) then T1T_{1} is killed else T2T_{2} waits. Assume any transaction that is not killed terminates eventually. Which of the following is TRUE about the database system that uses the above algorithm to prevent deadlocks?

Sign in to save attempts.

Loading…