Which ACID property ensures that committed data persists after a system failure?

Atomicity

Durability

Durability is about permanence. It guarantees that once a transaction is committed, its changes are permanent and will survive a system crash or power failure. This relies on mechanisms like write-ahead logging and storing committed updates on non-volatile storage (disks or replicated backups) so the system can recover and replay those changes after a failure. Atomicity is about all-or-nothing behavior for a single transaction, not whether its results survive a crash. Isolation controls how transactions appear to each other during concurrent execution. Consistency ensures the database rules and constraints are preserved, but it doesn’t by itself ensure that committed data won’t be lost after a failure.

Isolation

Consistency

Want more questions?

All options are one-time payments.

$25.99

30 day premium pass

All the basics to get you started

  • Ad-free experience
  • View your previous attempt history
  • Mobile app access
  • In-depth explanations
  • 30 day premium pass access
$59.99 $171.99 usd

6 month DELUXE pass (most popular)

Everything with the 30 day premium pass FOR 6 MONTHS! & the ultimate digital PDF study guide (BONUS)

  • Everything included in the premium pass
  • $171.99 usd value for $59.99! You save $106!
  • + Access to the ultimate digital PDF study guide
  • + 6 months of premium pass access
  • + Priority support
$15.99 $24.99

Ultimate digital PDF study guide

For those that prefer a more traditional form of learning

  • Available for instant download
  • Available offline
  • Hundreds of practice multiple choice questions
  • Comprehensive content
  • Detailed explanations
Image Description
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy