search
Log In

Recent questions tagged two-phase-locking-protocol

0 votes
3 answers
1
In conservative two phase locking protocol, a transaction Should release all the locks only at the beginning of transaction Should release exclusive locks only after the commit operation Should acquire all the exclusive locks at the beginning of transaction Should acquire all the locks at the beginning of transaction
asked Mar 30 in Databases Lakshman Patel RJIT 181 views
0 votes
1 answer
2
Is basic 2 phase locking always recoverable?
asked Jun 10, 2019 in Databases Hirak 174 views
0 votes
0 answers
3
A' is set of all possible schedules 'C' is set of all possible schedules that are guaranteed to produce a correct final result 'S' is the set of all serializable schedules 'P' is the set of all schedules possible under 2-phase locking protocol Which is FALSE? $P\subseteq C$ $S\subset P$ $S\subseteq P$ $P\subset C$
asked May 28, 2019 in Databases aditi19 227 views
1 vote
1 answer
5
How 2PL guarenteed serializability? I think conflict serializability is not guarenteed for 2PL. But may be view serializable Plz explain it
asked Jul 28, 2018 in Databases srestha 299 views
0 votes
1 answer
6
0 votes
1 answer
7
Which of the following is correct ? I.Two phase locking is an optimistic protocol. II. Two phase locking is pessimistic protocol III. Time stamping is an optimistic protocol. IV. Time stamping is pessimistic protocol. A I and III B II and IV C I and IV D II and III
asked Jun 30, 2018 in Databases bts 234 views
0 votes
1 answer
8
Consider the following schedule: Which of the following is correct about above schedule? $Schedule(S)$ is not conflict serializable schedule. $Schedule(S)$ is allowed by $2PL$. $Schedule(S)$ is strict recoverable schedule. $Schedule(S)$ is allowed by strict $2PL$. Reason Please
asked May 26, 2018 in Databases Na462 145 views
1 vote
1 answer
9
We know, Conservative 2PL is another name of Strict 2PL. But According to Navathe book Conservative 2PL is deadlock free,but Strict 2PL can have deadlock. Then how both could be same??
asked Jan 27, 2018 in Databases srestha 1.4k views
1 vote
1 answer
10
Sort these various versions of Two Phase locking protocols in increasing order of restricted-ness: 1. 2-PL(normal) 2. S-2PL(Strict) 3. R-2PL(Rigorous) 4. C-2PL (Conservative) 5. LC-2PL(Lock Conversion)
asked Aug 13, 2017 in Databases Tuhin Dutta 523 views
4 votes
1 answer
11
Does the conservative two phase locking protocol produce cascadeless schedules? Let us consider the following schedule : Since in the schedule the lock on a is released, it is possible for the transaction T2 to acquire the lock on a. Now the transaction T2 ... purposes. Does it mean that even though a conservative two phase protocol is used, the schedules may not necesssarily be cascadeless?
asked Jul 25, 2017 in Databases shashank023 2.5k views
To see more, click for the full list of questions or popular tags.
...