436 views
0 votes
0 votes

https://gateoverflow.in/1484/gate1999-2-6

in this questions after T2 is not granted exclusive lock on A does the transaction T2 gets blocked entirely or it can continue to acquire exclusive lock on B?

and if T2 continues to acquire lock on B followed by T1 requesting for read and write lock on B successively, is it deadlock situation here? And is that why it is not 2PL?

Please log in or register to answer this question.

Related questions

3 votes
3 votes
1 answer
1
shivangi5 asked Dec 6, 2017
1,172 views
Consider the following schedule:S:R2(A) W1(B) W1(C) R3(B) R2(B) R1(A) C1 R2(C) C2 W3(A)C3Please explain how it is allowed in 2 PL
1 votes
1 votes
1 answer
2
Kushagra Gusain asked Sep 7, 2017
992 views
Why is cascading rollback possible in 2 phase locking protocol, we know it guarantee serializability and serializable schedule are strict, which implies it is cascadeless...
2 votes
2 votes
2 answers
3
srestha asked Sep 16, 2017
2,811 views
State True or False and Tell reason1) 2PL is always conflict serializable2)Timestamp protocol is conflict and view serializable
1 votes
1 votes
1 answer
4
palashbehra5 asked Jan 17, 2022
968 views
Given Problem : S1 can be shown allowed under 2PL.However, the solution that they have provided for S2 : Seems wrong, as So, is S2 allowed under 2PL, or the answer give...