search
Log In
2 votes
178 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 178 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

2 votes
0 answers
1
126 views
Which of the following transaction(s) follow 2-phase locking protocol? lock1(a)read1(a)lock2(b)write2(b)lock1(c)unlock2(b)unclock1(c)lock2(c)unlock1(a) lock1(a)lock1(b)unlock1(a)lock2(a)write2(a)unlock2(a)unlock1(b) lock1(a)lock2(b)lock1(c)lock3(d)unlock2(b)lock3(b)unlock1(a)unlock3(d)unlock1(c)lock3(c) 1. Only 1 2. Only 2 3. Only 1 and 3 4. None of them
asked Sep 29, 2017 in Databases gulsanchouhan 126 views
3 votes
2 answers
2
113 views
Choose the correct option about the following schedule. S:R2(A);W3(A);(commitT3);W1(A);(commitT1);W2(B);R2(C);(commitT2);R4(A);R4(B);(commitT4) 1. S is both recoverable and conflict serializable 2. S is neither recoverable nor conflict serializable 3. S is recoverable but not conflict serializable 4. S is not recoverable but conflict serializable
asked Sep 29, 2017 in Databases gulsanchouhan 113 views
1 vote
0 answers
3
130 views
Which of the following can be described as a programming model used to develop applications processing massive amounts of data in a distributed and/or parallel manner? 1. Map Reduce 2 .OLAP 3. Mahout 4. Cloud Computing
asked Sep 29, 2017 in Databases gulsanchouhan 130 views
1 vote
0 answers
4
96 views
Consider the following database Col 1 Col 2 Col 3 1 2 3 4 5 6 7 8 9 If Col1 and Col2 form a column family and Col3 is another column family, how is the data stored? A. 1 2 3 4 5 6 7 8 9 B. 1 4 7 2 5 8 3 6 9 C. 1 2 4 5 7 8 3 6 9 D. 1 4 7 3 6 9 2 5 8
asked Sep 29, 2017 in Databases gulsanchouhan 96 views
...