retagged by
2,712 views
2 votes
2 votes

In conservative two phase locking protocol, a transaction

  1. Should release all the locks only at the beginning of transaction
  2. Should release exclusive locks only after the commit operation
  3. Should acquire all the exclusive locks at the beginning of transaction
  4. Should acquire all the locks at the beginning of transaction
retagged by

3 Answers

9 votes
9 votes

To ensure the serializability, we need two-phase locking protocol (2PL).

2PL has four cases:

  • Simple or Basic
  • Conservative
  • Strict
  • Rigorous

In Conservative 2-PL we need to lock all the data items which the transaction required before the transaction starts. And for its conservative nature, this protocol is deadlock free but starvation can occur.

So, the ans. is (D) Should acquire all the locks only at beginning of transaction.   

edited by
1 votes
1 votes
The answer is D as in conservative 2-PL locking protocol, all the locks(shared and exclusive) are taken at the beginning of the transaction and released after the transaction commits.
Answer:

Related questions

0 votes
0 votes
4 answers
1
admin asked Mar 30, 2020
4,901 views
Consider the relational schema $R(A B C D)$ with following $FD$ set $F=\{A \to CE, B \to D, AE \to D\}$. Identify the highest normal form satisfied by the relation $R$.$2...
1 votes
1 votes
1 answer
2
admin asked Mar 30, 2020
2,401 views
The condition for total participation of entity in a relationship is _______.Maximum cardinality should be oneMinimum cardinality should be oneMinimum cardinality should ...
3 votes
3 votes
2 answers
4