The Gateway to Computer Science Excellence
+2 votes
99 views
Which of the following statement is correct ?
1. 2 phase locking protocol does not suffer with problem of cascading rollback
2. Strict 2 phase protocol never results in deadlock
3. In strict 2 phase protocol, restriction of releasing exclusive locks until commit ensures no cascading rollbacks
4. Time-stamp ordering protocol can generate non-recoverable schedules
in Databases by (249 points) | 99 views
+1

1. 2 phase locking protocol does not suffer with problem of cascading rollback : False( it must be strict 2pl.)
2. Strict 2 phase protocol never results in deadlock. False ( It can be in deadlock)
3. In strict 2 phase protocol, restriction of releasing exclusive locks until commit ensures no cascading rollbacks. True
4. Time-stamp ordering protocol can generate non-recoverable schedules. False ( always recoverable)

0
4 .if timestamp is strict then it only give recoverable schedule as they are cascadless. but, Basic time stamp only ensure serilizablity not recoverable it may be non-recoverable.

Please log in or register to answer this question.

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,647 questions
56,508 answers
195,532 comments
100,971 users