GATE CS 2024 Set 2 — Question 19

MCQ+1 / -0.33EasyACID PropertiesTransactions & ConcurrencyDatabases

Databases → Transactions & Concurrency → ACID Properties

Last updated 20 August 2026

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

Correct answer (A) durability Solution The property described is Durability . Durability ensures that once a transaction has been committed, it will remain so, even in the event of power loss, crashes, or errors. Atomicity ensures that all operations within a work unit are completed successfully; otherwise, the transaction is aborted at the point of failure and previous operations are rolled back. Consistency ensures that the database properly changes states upon a successfully committed transaction. Isolation enables transactions to operate independently of and transparent to each other. Turn this into a strength. Explore AI-powered practice and doubt support with Success Tracker.

Review answer and solution without JavaScript

Interactive answer checking needs JavaScript. The published solution is available below.

Correct answer (A) durability Solution The property described is Durability . Durability ensures that once a transaction has been committed, it will remain so, even in the event of power loss, crashes, or errors. Atomicity ensures that all operations within a work unit are completed successfully; otherwise, the transaction is aborted at the point of failure and previous operations are rolled back. Consistency ensures that the database properly changes states upon a successfully committed transaction. Isolation enables transactions to operate independently of and transparent to each other.

Continue learning with Success Tracker

Use Success Tracker to ask about the reasoning, then try another GATE CS question to check your understanding.

AI-powered practice· Unlimited practice on eligible plans

PYQs with solutions: Attempt available previous-year questions, then compare your reasoning with the worked solution. Coverage varies by stream.
Practice that adapts: Choose a topic, work on weaker areas and bookmark questions to revisit. Your attempts feed your progress tracking.
AI doubt support: Ask follow-up questions about a step or concept while practising, instead of stopping at the final answer.

Unlimited practice is available on eligible plans. Free practice and AI usage have limits; check the current plan allowances before choosing.

This page stays readable without an account. AI responses can be wrong; check them against the solution and source material.