1,232 views
0 votes
0 votes

Which of the following is correct ? I.Two phase locking is an optimistic protocol. II. Two phase locking is pessimistic protocol III. Time stamping is an optimistic protocol. IV. Time stamping is pessimistic protocol.

A

I and III

B

II and IV

C

I and IV

D

II and III

1 Answer

0 votes
0 votes
validation protocol is optimistic protocol while locking and timestamps are pessimistic protocols.

so ii and iv. are correct.

Related questions

1 votes
1 votes
1 answer
1
srestha asked Jul 28, 2018
1,216 views
How 2PL guarenteed serializability? I think conflict serializability is not guarenteed for 2PL. But may be view serializable Plz explain it
1 votes
1 votes
1 answer
3
Tuhin Dutta asked Aug 13, 2017
1,927 views
Sort these various versions of Two Phase locking protocols in increasing order of restricted-ness:1. 2-PL(normal)2. S-2PL(Strict)3. R-2PL(Rigorous)4. C-2PL (Conservative)...
2 votes
2 votes
1 answer
4
techbrk3 asked Nov 9, 2017
1,635 views
The time stamp of two transactions T1 and T2 are 10 and 15 respectively. Consider the following schedule with T1 and T2 operations.S1:r1(x),w1(x),r2(x),w2(x),r1(y),w1(y),...