GATE2019
closed

closed by
1,132 views
2 votes
2 votes
closed as a duplicate of: GATE CSE 2019 | Question: 11
5  Q.  Given Statement.   

I. Strict 2 – Phase lock protocol generate Conflict Serializable schedule that are also recoverable

II. Time stamp – ordering concurrency control protocol with Thomas write rule can generate view serialized schedule that are not conflict serializable  which are True?

A. Only I   B. Only II  C. Both True   D. Both are false
closed by

1 Answer

3 votes
3 votes
Both are true.

Strict 2 phase locking protocol accepts only cascadeless recoverable conflict serializable schedules.

Thomas write rule allows some view serializable schedules too , which are not conlict serializable.

Basic timestamp ordering protocol accepts view serializable schedules which are also conflict serializable.

Related questions

1 votes
1 votes
0 answers
1
0 votes
0 votes
0 answers
2
mradul asked Feb 9, 2019
660 views
I am getting 62.34 marks and my rank according to gateoverflow rank predictor wil be between 400-500.Is there any chance of getting iit in cs