# Recent questions tagged two-phase-locking-protocol

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
2
Is basic 2 phase locking always recoverable?
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$
4
Please explain. Use the below transaction.
1 vote
5
How 2PL guarenteed serializability? I think conflict serializability is not guarenteed for 2PL. But may be view serializable Plz explain it
6
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
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
1 vote