Once the informs the user that a transaction has been successfully completed, its effect should persist even if the system crashes before all its changes are reflected on disk. This property is called
View worked solution
Answer: A
The correct option is A.
This question refers to the standard ACID properties of a database transaction:
- Durability (D): Guarantees that once a transaction has been committed (successfully completed), its updates survive any subsequent system failures or crashes, even if the changes have not yet been physically written to the disk.
- Atomicity (A): Ensures that either all operations of a transaction are completed successfully, or none of them are (all-or-nothing).
- Consistency (C): Ensures that a transaction brings the database from one valid state to another, maintaining all database schemas, constraints, and rules.
- Isolation (I): Ensures that the concurrent execution of transactions results in a state equivalent to if they were executed serially.
Thus, the property described in the question is durability.
Free practice · Your answers on this page are not saved.