GATE | Gate IT 2005 | Question 24

Amongst the ACID properties of a transaction, the ‘Durability’ property requires that the changes made to the database by a successful transaction persist

 
(A) Except in case of an Operating System crash
(B) Except in case of a Disk crash
(C) Except in case of a power failure
(D) Always, even if there is a failure of any kind


Answer: (D)

Explanation: ACID properties:

Atomicity: By this, we mean that either the entire transaction takes place at once or doesn’t happen at all.
Consistency: This means that integrity constraints must be maintained so that the database is consistent before and after the transaction.
Isolation: This property ensures that multiple transactions can occur concurrently without leading to inconsistency of database state.
Durability: This property ensures that once the transaction has completed execution, the updates and modifications to the database are stored in and written to disk and they persist even if system failure occurs no matter which type of failure.

Therefore option D

 

Quiz of this Question

My Personal Notes arrow_drop_up
Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.