Durability - Definition - Database

Q.  What is durability?
- Published on 26 Aug 15

a. When an update occurs to a database, either all or none of the update becomes available to anyone
b. The transactions have been committed and will survive permanently
c. It determines how the transaction integrity will be visible to the other users and systems
d. All of the above

ANSWER: When an update occurs to a database, either all or none of the update becomes available to anyone

Related Content

 

    Discussion

  • Nava Bogatee   -Posted on 26 Apr 16
    The answer should be :
    b. The transactions have been committed and will survive permanently

    Durability. Committed data is saved by the system such that, even in the event of a failure and system restart, the data is available in its correct state.
  • Nirja Shah   -Posted on 03 Nov 15
    Durability
    - Maintaining the updates of a committed transactions is critical.

    - These updates must never be lost.

    - This property refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.

    - Features of durability:
    1. Recovery to the most recent successful commit after a database software failure

    2. Recovery to the most recent successful commit after an application software failure

    3. Recovery to the most recent successful commit after a CPU failure

    4. Recovery to the most recent successful backup after a disk failure

    5. Recovery to the most recent successful commit after a data disk failure

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲