3,306 views
1 votes
1 votes

Consider the following schedule
            S : r1(A) w2(A) commit2, w1(A) w3(A) commit3, commit1
Which of the following is true?

a) Schedule is view serializable schedule and strict recoverable schedule

b) Schedule is non serializable schedule and strict recoverable schedule

c) Schedule is non serializable schedule and not strict recoverable schedule

d)Schedule is serializable schedule and not strict recoverable schedule

2 Answers

3 votes
3 votes

hence answer is option d.

1 votes
1 votes

Yes!. The answer id option D.

It is not strict recoverable schedule and doesn't statisfy the conflict serializable, but we have blind write so checking for view serializable and it statisfies view serializable.

Related questions

0 votes
0 votes
1 answer
1
atulcse asked Jan 10, 2022
381 views
Consider the following schedule:R2(A), R1(A), R3(B), W3(B), W2(A), R1(A)Is the above schedule view serializable?
0 votes
0 votes
1 answer
2
atulcse asked Nov 2, 2021
434 views
Can a schedule be serializable if it is not view serializable? Are conflict equivalence and view equivalence the only two ways to decide if a schedule is serializable?
1 votes
1 votes
1 answer
3
Na462 asked Jan 13, 2019
1,478 views
Consider following Schedule S with data item x :S : W1(X) R2(X) W3(X) R4(X) W5(X) R6(X) W7(X) R8(X) W9(X) R10(X)The number of schedule view equivalent to Schedule S but n...
1 votes
1 votes
1 answer
4
shreejeetp asked Dec 14, 2018
295 views
Is every serializable schedule view serializable?, or like conflict serializable, there could be a serializable schedule which isn’t view serializable?