retagged by
455 views
3 votes
3 votes

Which of the following is TRUE about the given schedule S?

$\begin{array}{|c|c|} \hline  \text{Schedule:} & S \\ \hline T1 & T2 \\ \hline R(A) & {} \\ \hline A=A+100 & {} \\ \hline {} & R(A) \\ \hline {} & A=A^*2 \\ \hline {} & W(A) \\ \hline W(A) & {} \\ \hline {} & R(B) \\ \hline {} & B=B/2 \\ \hline {} & W(B) \\ \hline R(B) & {} \\ \hline B=B-100 & {} \\ \hline W(B) & {} \\ \hline \end{array}$                                

  1. It is conflict serializable.
  2. It is view serializable but not conflict serializable.
  3. It is conflict serializable but not view serializable.
  4. It is not serializable.
retagged by

2 Answers

Best answer
1 votes
1 votes
Not conflict serializable
selected by
1 votes
1 votes
Shouldn't the answer be option B

because

For View serializable schedule

1) Final writes:

            A: T2,T1 therefore T2->T1

            B: T2,T1 therefore T2->T1

2) Initial read:

data item | intial read | write

   A            | T1,T2          | T2,T1 -----------------no condition

   B            | T2               | T2,T1 -----------------T2->T1

3) Updated read:

    W2(B)-->R1(B) ---------------T2-->T1

from 1,2,3 T2---->T1 is serial schedule
Answer:

Related questions

1 votes
1 votes
1 answer
1
aditi19 asked Nov 17, 2018
1,130 views
Tl:W(X), T2:R(X), Tl:W(X), T2:Commit, Tl:Abortis this schedule conflict serializable?
1 votes
1 votes
1 answer
2
1 votes
1 votes
1 answer
4