Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

GATE | Gate IT 2005 | Question 24

  • Last Updated : 28 Jun, 2021

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
Recommended Articles
Page :

Start Your Coding Journey Now!