Transactions
|
Question 12
|
Consider the following transaction involving two bank account x and y.
read(x); x:= x-50; write(x); read(y); y:= y+50; write(y)
The constraint that the sum of the accounts x and y should remain constant is that of
|
Atomicity
|
|
|
Consistency
|
|
|
Isolation
|
|
|
Durability
|
Question 12 Explanation:
The consistency property ensures that the database remains in a consistent state before the (start of the transaction and after the transaction is over. Here sum of the accounts x & y should remain same before & after execution of the given transactions which refers to the consistency of the sum.
Correct Answer: B
Question 12 Explanation:
The consistency property ensures that the database remains in a consistent state before the (start of the transaction and after the transaction is over. Here sum of the accounts x & y should remain same before & after execution of the given transactions which refers to the consistency of the sum.
Subscribe
Login
0 Comments