Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

GATE | GATE-CS-2015 (Set 2) | Question 11

  • Difficulty Level : Easy
  • Last Updated : 28 Jun, 2021

Consider the following transaction involving two bank accounts 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

(A) Atomicity
(B) Consistency
(C) Isolation
(D) Durability

Answer: (B)

Explanation: Consistency in database systems refers to the requirement that any given database transaction must only change affected data in allowed ways, that is sum of x and y must not change.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!