Register

Two phase locking and time stamp

1,594 views
0 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 0 votes
validation protocol is optimistic protocol while locking and timestamps are pessimistic protocols.

so ii and iv. are correct.
Voting & Accepting an answer helps improve the community
← Previous · self doubtNext → · Question bank for ga...
← Previous in category · B+ tree DoubtNext in category → · Tuple relational cal...
Position:
Show:

Related questions

1 1 vote
1 1 answer
2.2k
2.2k views
srestha asked Jul 28, 2018
2,163 views
Two Phase Locking
How 2PL guarenteed serializability? I think conflict serializability is not guarenteed for 2PL. But may be view serializable Plz explain it
4 4 votes
1 1 answer
7.2k
7.2k views
shashank023 asked Jul 25, 2017
7,169 views
conservative two phase locking protocol
Does the conservative two phase locking protocol produce cascadeless schedules?Let us consider the following schedule :Since in the schedule the lock on a is released, it...
1 1 vote
1 1 answer
364
364 views
Eldho_G_Peter asked Dec 14, 2024
364 views
self doubt: rigorous 2 phase locking
can someone explain why the order of transactions in a rigorous 2 phase locking is same as order of commit operations and not order of lock points as in standard 2 phase ...
1 1 vote
1 answers 1 answer
1.9k
1.9k views
palashbehra5 asked Jan 17, 2022
1,920 views
2 Phase Locking | Made Easy Test Series
Given Problem : S1 can be shown allowed under 2PL.However, the solution that they have provided for S2 : Seems wrong, as So, is S2 allowed under 2PL, or the answer give...