me adv test
[closed]

in Databases retagged by
495 views
0 votes
0 votes
Consider the following schedule:
S:R2(A), W1(B), W1(C), R3(B), R2(B), R1 (A), commit_1, R2(C), commit_2, W3(A), commit_3

How many given statements true about schedule(S)____.

(i) Schedule(S) is conflict serializable schedule.
(ii) Schedule(S) is allowed by 2PL.
(iii) Schedule(S) is strict recoverable schedule.
(iv) Schedule(S) is allowed by strict 2PL.

only 1 is correct as per my answer but in answer they have given 3
in Databases retagged by
495 views

5 Comments

Refer this.

1
1
2 statements are correct here (i) and (ii)
0
0
according to me 1,2 and 4 are satisfied.
0
0
To understand why 4th us not true refer the above link.
0
0
Only 1,2 correct

This schedule can't be strict.
0
0

Related questions