retagged by
317 views
2 votes
2 votes

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);} \\ \hline \text{read(B);} \\ \hline B:=B+250; \\ \hline \text{write(B);} \\ \hline \end{array}$

The constraint that the sum of the accounts $A$ and $B$ should remain constant is that of:

  1. Atomicity
  2. Consistency
  3. Isolation
  4. Durability
retagged by

1 Answer

Best answer
2 votes
2 votes

The database must remain in a consistent state after any transaction. No transaction should have any adverse effect on the data residing in the database. If the database was in a consistent state before the execution of a transaction, it must remain consistent after the execution of the transaction as well. 

Ans:B

selected by
Answer:

Related questions

1 votes
1 votes
1 answer
1
1 votes
1 votes
1 answer
2
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
3