The . . . . . . . . property states that the system must have a mechanism to recover from committed transactions should that be necessary.

atomicity
consistency
isolation
durability

The correct answer is D. durability.

The durability property states that once a transaction has been committed, it will be permanently stored in the database, even if there is a system failure. This ensures that data is not lost or corrupted.

The other three properties are:

  • Atomicity: A transaction is either committed or rolled back, there is no middle ground.
  • Consistency: Once a transaction has been committed, the database will be in a consistent state.
  • Isolation: Concurrent transactions cannot interfere with each other.

I hope this helps! Let me know if you have any other questions.

Exit mobile version