6,509 views
34 votes
34 votes

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

  1. Except in case of an Operating System crash
  2. Except in case of a Disk crash
  3. Except in case of a power failure
  4. Always, even if there is a failure of any kind

1 Answer

Best answer
112 votes
112 votes

Answer d. Irrespective of any failure the successful result of transaction should persist.

Suppose we book ticket $2$ months in advance in irctc and transaction success.

Then when we are going to board the train on that time they tells because of system/disk/power crash they dont have your seat information and you are not allowed in the seat.

it is a serious problem. hence result should persist irrespective of all crashes.

Answer:

Related questions

27 votes
27 votes
5 answers
2
Ishrat Jahan asked Nov 3, 2014
7,216 views
A table has fields $F_1, F_2, F_3, F_4, F_5$ with the following functional dependencies $F_1 \to F_3, F_2\to F_4, (F_1 . F_2) \to F_5$In terms of Normalization, this ...