DS0-001 · Question #42
A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?
The correct answer is A. Durability. The property that addresses this concern is durability. Durability is one of the four properties (ACID) that ensure reliable transactions in a database system. Durability means that once a transaction has been committed, its effects are permanent and will not be lost in case of…
Question
A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?
Options
- ADurability
- BIsolation
- CAtomicity
- DConsistency
How the community answered
(42 responses)- A90% (38)
- B5% (2)
- C2% (1)
- D2% (1)
Explanation
The property that addresses this concern is durability. Durability is one of the four properties (ACID) that ensure reliable transactions in a database system. Durability means that once a transaction has been committed, its effects are permanent and will not be lost in case of system failure, power outage, crash, etc. Durability can be achieved by using techniques such as write- ahead logging, checkpoints, backup and recovery, etc. The other options are either not related or not specific to this concern. For example, isolation means that concurrent transactions do not interfere with each other and produce consistent results; atomicity means that a transaction is either executed as a whole or not at all; consistency means that a transaction preserves the validity and integrity of the data.
Topics
Community Discussion
No community discussion yet for this question.