search
Log In

Recent questions tagged -2phaselocking

0 votes
1 answer
1
How can 2PL protocol ( simple one ) ensure conflict serializability even though it cannot ensure freedom from deadlock ? I mean ,if a schedule is conflict serializable it has a conflict equivalent to a serial schedule and serial schedules won't have deadlocks .Right ?
asked Mar 30, 2019 in Databases ashunimbz 125 views
0 votes
0 answers
2
0 votes
0 answers
3
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?
asked Nov 11, 2018 in Databases aditi19 111 views
0 votes
0 answers
4
2 votes
1 answer
5
Consider the following schedule: S:R2(A) W1(B) W1(C) R3(B) R2(B) R1(A) C1 R2(C) C2 W3(A)C3 Please explain how it is allowed in 2 PL
asked Dec 6, 2017 in Databases shivangi5 279 views
0 votes
2 answers
6
State True or False and Tell reason 1) 2PL is always conflict serializable 2)Timestamp protocol is conflict and view serializable
asked Sep 16, 2017 in Databases srestha 937 views
1 vote
1 answer
7
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? Please clear the doubt and correct me.
asked Sep 7, 2017 in Databases Kushagra Gusain 467 views
To see more, click for the full list of questions or popular tags.
...