UTpaper

Free mock tests & test series

Question 26Asked in UGC NET Computer Science, June 2015 (Paper II & III, Selected Questions)

Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock?

Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock? (1) 2-phase Locking (2) Time stamp - ordering
  1. ABoth (1) and (2)
  2. B(1) only
  3. C(2) only
  4. DNeither (1) nor (2)
Show answerHide answer

Correct answer: (C) (2) only

Explanation

In basic two-phase locking there is a chance of deadlock. The timestamp-ordering protocol ensures conflict serializability and, since no transaction waits, it is free from deadlock. So the answer is (2) only.

From UGC NET Computer Science PYQ, June 2015 (Paper II & III, Selected Questions)

This is question 26 of UGC NET Computer Science PYQ, June 2015 (Paper II & III, Selected Questions). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.