Register

UGC NET CSE | June 2014 | Part 3 | Question: 27, UGCNET-June2015-II: 17

• edited by
1,550 views
0 votes
0 votes

Which of the following concurrency protocol ensues both conflict serializability and freedom from deadlock:

  1. $2$-phase locking
  2. Time phase ordering
  1. Both I & II
  2. II only
  3. I only
  4. Neither I nor II
• edited by
User Avatar

2 Answers

1 votes
1 votes

2 Phase Locking (2PL) is a concurrency control method that guarantees serializability. The protocol utilizes locks, applied by a transaction to data, which may block (interpreted as signals to stop) other transactions from accessing the same data during the transactions life. 2PL may be lead to deadlocks that result from the mutual blocking of two or more transactions. 
Timestamp-based concurrency control algorithm is a non-lock concurrency control method. In Timestamp based method, deadlock cannot occur as no transaction ever waits.

ans is B

User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

17 votes
17 votes
3 answers
1
Kathleen asked Sep 21, 2014
7,718 views
GATE CSE 2007 | Question: 39, UGCNET-June2015-II: 22
The inorder and preorder traversal of a binary tree are $\text{d b e a f c g}$ and $\text{a b d e c f g}$, respectively The postorder traversal of the binary tree is: $\text{d e b f g c a}$ $\text{e d b g f c a}$ $\text{e d b f g c a}$ $\text{d e f g b c a}$
The inorder and preorder traversal of a binary tree are$\text{d b e a f c g}$ and $\text{a b d e c f g}$, respectivelyThe postorder traversal of the binary tree is:$\text...
User Avatar
2 votes
2 votes
1 answer
2
makhdoom ghaya asked Jul 24, 2016
1,603 views
UGC NET CSE | December 2014 | Part 2 | Question: 50
Match the following $:$ ... $\text{a-i, b-ii, c-iii, d-iv }$ $\text{a-iv, b-iii, c-ii, d-i}$
Match the following $:$ $\begin{array}{clcl} & \textbf{List – I} && \textbf{List – II} \\ \text{a.} & \text{Call Control protocol} &\text{i.} & \text{Interface b...
User Avatar
Link Copied!