retagged by
388 views
3 votes
3 votes

Consider the following schedule:

$\begin{array}{|l|l|} \hline T1 & T2 \\ \hline {} & \text{Read (A)}  \\ \hline {} &  A = A + 10 \\ \hline {} &  \text{ Read (B)} \\ \hline {} &  A =B +10 \\ \hline {} & \text{Write (A)} \\ \hline \text{Read (B)} & {} \\ \hline B = B+ 10 & {} \\ \hline \text{Read (A)} & {} \\ \hline B = A+ 10 \\ \hline \text{write (B)} & {} \\ \hline \text{commit} & {} \\ \hline {} &  \text{commit} \\ \hline \end{array}$

Which of the following transaction problems is present in the given schedule ?

  1. Lost update
  2. Dirty Rea
  3. Unrepeatable read
  4. Both (A) & (B)
retagged by

1 Answer

Best answer
2 votes
2 votes
A T1 transaction is reading uncommitted data that is written by transaction T2 on data item A, it is also known write read conflict or Dirty read problem...
selected by
Answer:

Related questions

1 votes
1 votes
1 answer
1
2 votes
2 votes
1 answer
2
Bikram asked Aug 26, 2017
317 views
Consider the following transaction involving two bank accounts $A$ and $B$.$\begin{array}{|l|} \hline \text{read(A);} \\ \hline A:=A-250; \\ \hline \text{write(A);} \\ \...
1 votes
1 votes
1 answer
3
Bikram asked Aug 26, 2017
294 views
A schedule with two transactions T1 and T2 is as mentioned below:$\begin{array}{|c|c|} \hline T1 & T2 \\ \hline \text{read(A)} & {} \\ \hline \text{write(A)} & {} \\ \hl...
3 votes
3 votes
2 answers
4