A developer notices that after a system crash, some committed transactions are lost. Which ACID property is likely violated, and what should be fixed?

medium📝 Debug Q14 of 15

SQL - Transactions and Data Integrity

AAtomicity; ensure transactions are all-or-nothing

BConsistency; fix data validation rules

CIsolation; improve transaction locking

DDurability; improve data saving and recovery

Step-by-Step Solution

Solution:

Step 1: Identify property related to crash recovery
Durability ensures committed transactions survive crashes and are saved permanently.
Step 2: Match problem to property
Lost committed transactions after crash means Durability is violated and saving/recovery must be improved.
Final Answer:
Durability; improve data saving and recovery -> Option D
Quick Check:
Crash survival = Durability [OK]

Quick Trick: Lost data after crash means Durability issue [OK]

Common Mistakes:

Confusing Atomicity with crash recovery
Thinking Isolation fixes lost data
Mixing Consistency with durability problems

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More SQL Quizzes

A developer notices that after a system crash, some committed transactions are lost. Which ACID property is likely violated, and what should be fixed?

Step 1: Identify property related to crash recovery

Step 2: Match problem to property

Final Answer:

Quick Check:

Want More Practice?