Which statement correctly describes a scenario highlighting the ACID property of durability? A) All database records are immediately flushed to disk after an update. B) User reques... Which statement correctly describes a scenario highlighting the ACID property of durability? A) All database records are immediately flushed to disk after an update. B) User requests can still be processed while a transaction is underway. C) Database state is preserved despite a power failure occurring post-update. D) A transaction can be rolled back in case of a failure.
Understand the Problem
The question is asking which statement best illustrates the ACID property of durability in a database context. Each option presents different aspects of database transactions, but only one correctly embodies the principle of ensuring that once a transaction has been committed, it will remain so, even in the event of a failure.
Answer
Database state is preserved despite a power failure occurring post-update.
The correct statement is: "Database state is preserved despite a power failure occurring post-update."
Answer for screen readers
The correct statement is: "Database state is preserved despite a power failure occurring post-update."
More Information
Durability in the context of ACID properties ensures that once a transaction has been committed, it remains saved even in events like power failures. This guarantees the persistence of data after successful transaction completion.
Sources
AI-generated content may contain errors. Please verify critical information
