Register

2 Phase Locking

691 views
0 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.

Voting & Accepting an answer helps improve the community
← Previous · MADEEASYNext → · Push Down Automata
← Previous in category · GeeksforGeeks test S...Next in category → · Conflict serialisabl...
Position:
Show:

Related questions

1 1 vote
1 1 answer
374
374 views
Eldho_G_Peter asked Dec 14, 2024
374 views
self doubt: rigorous 2 phase locking
can someone explain why the order of transactions in a rigorous 2 phase locking is same as order of commit operations and not order of lock points as in standard 2 phase ...
1 1 vote
1 answers 1 answer
2.0k
2.0k views
palashbehra5 asked Jan 17, 2022
1,964 views
2 Phase Locking | Made Easy Test Series
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...
3 3 votes
1 1 answer
2.5k
2.5k views
shivangi5 asked Dec 6, 2017
2,498 views
2 Phase Locking
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 1 vote
1 1 answer
1.4k
1.4k views
Kushagra Gusain asked Sep 7, 2017
1,432 views
Serializability and 2 phase locking protocol
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...