edited by
659 views
1 votes
1 votes

Consider the following two phase locking protocol. Suppose a transaction $\text{T}$ accesses (for read or write operations), a certain set of objects $\{\text{O1},\ldots, \text{Ok} \}$. This is done in the following manner:

  • $\text{Step 1}. \text{T}$ acquires exclusive locks to $\text{O1},\ldots, \text{Ok}$ in increasing order of their addresses.
  • $\text{Step 2}$. The required operations are performed.
  • $\text{Step 3}$. All locks are released

This protocol will

  1.  guarantee serializability and  deadlock-freedom 
  2.  guarantee neither serializability nor deadlock-freedom 
  3.  guarantee serializability but not deadlock-freedom  
  4.  guarantee deadlock-freedom but not serializability.
edited by

1 Answer

0 votes
0 votes

 

It is called as conservative 2PL

1)serializability

2)deadlock freedom

3) strict recoverable

4)starvation possible

5)Throughput decreases

6)degree of concurrency decreases

So Option (A) is Correct. 
 

Related questions

1 votes
1 votes
0 answers
4
soujanyareddy13 asked Apr 12, 2022
877 views
Match the following:$$\begin{array} {ll} \qquad \quad\textbf{List-I} & \qquad \quad \textbf{List-II} \\ \text{(P) Condition coverage} & \text{(1) Black-box testing} \\ \t...