ISRO | ISRO CS 2017 – May | Question 6

ACID properties of a transactions are
(A) Atomicity, consistency, isolation, database
(B) Atomicity, consistency, isolation, durability
(C) Atomicity, consistency, integrity, durability
(D) Atomicity, consistency, integrity, database

Answer: (B)
Explanation: Every transaction holds ACID properties.
A: Atomicity: Either a transaction should be performed completely or it should rollback.
C: Consistency: Every transaction specifies some consistency constraints and these constraints should follow even after transaction occurs.
I: Isolation: Every transaction should be performed in isolation so that no other transaction can see the intermediate result of any transaction.
D: Durability: Every transaction performed should be recorded and despite all the failures these records must persist.

Quiz of this Question