Dark Mode

Recent questions tagged -2phaselocking

0 votes

2 answers

1

Self doubt on 2PL protocol
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 ?

ashunimbz asked in Databases Mar 30, 2019

570 views

0 votes

0 answers

2

Does rigorous 2pl causes deadlock.

Manojkumar Susarla asked in Databases Jan 15, 2019

by Manojkumar Susarla

349 views

0 votes

0 answers

3

2 Phase Locking
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?

aditi19 asked in Databases Nov 11, 2018

436 views

3 votes

1 answer

4

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)C3 Please explain how it is allowed in 2 PL

shivangi5 asked in Databases Dec 6, 2017

1.2k views

2 votes

2 answers

5

2 Phase Locking
State True or False and Tell reason 1) 2PL is always conflict serializable 2)Timestamp protocol is conflict and view serializable

srestha asked in Databases Sep 16, 2017

2.8k views

1 vote

1 answer

6

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? Please clear the doubt and correct me.

Kushagra Gusain asked in Databases Sep 7, 2017

by Kushagra Gusain

1.0k views

To see more, click for the full list of questions or popular tags.

Recent questions tagged -2phaselocking