Discussion
Once the DBMS 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
Answer: A
The property is durability.
Durability, the D in ACID, guarantees that once a transaction commits and the user is told so, its effects survive later failures. The DBMS achieves this with a write-ahead log forced to stable storage at commit, so the changes can be redone after a crash even if the data pages had not yet been written.
Atomicity is all-or-nothing execution of a transaction. Consistency means a transaction takes the database from one valid state to another. Isolation means concurrent transactions do not see each other's partial effects. None of these is about surviving a crash after commit.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development