Computer Sciences > GATE 2024 Set-2 > DBMS
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
A
durability
B
atomicity
C
consistency
D
isolation

Correct : a

To identify the correct transaction property described in the statement, let us look at the standard ACID properties of a Database Management System (DBMS):
Atomicity: Ensures that all operations within a transaction are completed successfully; if any operation fails, the entire transaction is aborted and rolled back ("all or nothing").
Consistency: Ensures that a transaction transforms the database from one valid, consistent state to another valid state, preserving all pre-defined schema rules and constraints.
Isolation: Ensures that the concurrent execution of multiple transactions leaves the database in the same state as if they were executed sequentially, keeping incomplete modifications hidden from other transactions.
Durability: Ensures that once a transaction has been committed successfully and the user is notified of its completion, all updates made by that transaction become permanent. These changes must survive any subsequent system failures, software failures, or unexpected power crashes, even if the runtime modifications have not yet been written physically from memory cache to secondary storage disk.

The property that guarantees modifications persist through an unexpected system crash following a successful completion is durability. This corresponds directly to option (a).

Similar Questions

Which of the following file organizations is/are I/O efficient for the scan operation in DBMS?
#914 MSQ
Which of the following statements about the Two Phase Locking (2PL) protocol is/are TRUE?
#915 MSQ
A palindrome is a word that reads the same forwards and backwards. In a game of words, a player has the following two plates painted with letters. From...
#1 MCQ

Related Topics

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......