Question:
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
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
Show Hint
The ACID properties—Atomicity, Consistency, Isolation, and Durability—are fundamental to understanding transaction management in databases.
Updated On: Jan 23, 2025
- durability
- atomicity
- consistency
- isolation
Hide Solution
Verified By Collegedunia
The Correct Option is A
Solution and Explanation
The durability property ensures that once the DBMS confirms the successful completion of a transaction, its changes to the database are permanent and will persist even if there is a system failure. This property is one of the ACID properties of transactions.
Step 1: Analyze the other options.
(B) Atomicity ensures that a transaction is completed entirely or not at all, but it does not guarantee persistence after system crashes.
(C) Consistency ensures that a database remains in a valid state before and after a transaction, but it does not address persistence.
(D) Isolation ensures that transactions do not interfere with each other, but it does not guarantee durability.
Conclusion: Durability is the correct answer as it guarantees the effect of a committed transaction persists after system crashes.
Final Answer:
\[
\boxed{\text{durability}}
\]
Was this answer helpful?
0
0
Top Questions on Miscellaneous
- Given the matrix \[ A = (a_{ij}), \] where \[ A_{11} = \begin{bmatrix} 0 & 1 \\ 0 & 0 \end{bmatrix}, \quad A_{14} = \begin{bmatrix} 4 & 1 \\ 3 & 0 \end{bmatrix}, \quad A_{21} = \begin{bmatrix} 0 & 1 \\ 0 & 0 \end{bmatrix}, \quad A_{23} = \begin{bmatrix} 2 & 1 \\ 1 & 2 \end{bmatrix}, \quad \text{find} \, a_{23}. \]
- JEE Main - 2025
- Mathematics
- Miscellaneous
- By using relation \( \Delta G = \Delta H - T \Delta S \), which of the following is incorrect for a spontaneous reaction at a given temperature?
- JEE Main - 2025
- Mathematics
- Miscellaneous
- If a square is divided into \( 4 \times 4 \) squares. If two squares are chosen randomly, then the probability that the squares don't share a common side is:
- JEE Main - 2025
- Mathematics
- Miscellaneous
- Find the wavelength in (nm) of incident radiation where the work function is 4.12 eV and the stopping potential is 4V. Given that \( h \nu = 1242 \, \text{eV} \cdot \text{nm} \).
- JEE Main - 2025
- Physics
- Miscellaneous
- 81 g of Al reacts with 128 g of \( O_2 \). Calculate the amount of \( Al_2O_3 \) produced.
- JEE Main - 2025
- Chemistry
- Miscellaneous
View More Questions
Questions Asked in GATE CS exam
- The number of distinct minimum-weight spanning trees of the following graph is ............ \begin{center} \includegraphics[width=0.5\textwidth]{59.png} \end{center}
- GATE CS - 2024
- Syntax Directed Translation
- Consider a 32-bit system with a 4 KB page size and page table entries of size 4 bytes each. Assume \(1 \, \text{KB} = 2^{10} \, \text{bytes}\). The OS uses a 2-level page table for memory management, with the page table containing an outer page directory and an inner page table. The OS allocates a page for the outer page directory upon process creation. The OS uses demand paging when allocating memory for the inner page table, i.e., a page of the inner page table is allocated only if it contains at least one valid page table entry.
An active process in this system accesses \(2000\) unique pages during its execution, and none of the pages are swapped out to disk. After it completes the page accesses, let \(X\) denote the minimum and \(Y\) denote the maximum number of pages across the two levels of the page table of the process. The value of \(X + Y\) is ............- GATE CS - 2024
- Lexical analysis
- Consider the following augmented grammar, which is to be parsed with an SLR parser. The set of terminals is \(\{a, b, c, d, \#, @\}\). \[ S' \rightarrow S \quad S \rightarrow SS \, | \, Aa \, | \, bAc \, | \, BC \, | \, bBa \quad A \rightarrow d\# \quad B \rightarrow @ \] Let \(I_0 = \text{CLOSURE}(\{S' \rightarrow \cdot S\}\). The number of items in the set \(GOTO(I_0, S)\) is ............
- GATE CS - 2024
- Syntax Directed Translation
- Let \(Z_n\) be the group of integers \(\{0, 1, 2, \dots, n - 1\}\) with addition modulo \(n\) as the group operation. The number of elements in the group \(Z_2 \times Z_3 \times Z_4\) that are their own inverses is ............
- GATE CS - 2024
- Indexed Address
- A non-pipelined instruction execution unit operating at 2 GHz takes an average of 6 cycles to execute an instruction of a program \(P\). The unit is then redesigned to operate on a 5-stage pipeline at 2 GHz. Assume that the ideal throughput of the pipelined unit is 1 instruction per cycle. In the execution of program \(P\), 20\% instructions incur an average of 2 cycles stall due to data hazards and 20\% instructions incur an average of 3 cycles stall due to control hazards. The speedup (rounded off to one decimal place) obtained by the pipelined design over the non-pipelined design is ............
- GATE CS - 2024
- Indexed Address
View More Questions