MySQL + SQL · Lesson 83

ACID Properties in DBMS and MySQL

What are ACID Properties?

ACID are four properties that guarantee reliable transactions. Every DBMS exam asks this.

The Four Properties

PropertyMeaning
AtomicityAll steps happen, or none do
ConsistencyDatabase stays valid before and after
IsolationConcurrent transactions do not interfere
DurabilityCommitted data survives crashes

Example

In a bank transfer: Atomicity ensures both debit and credit happen together; Durability ensures that once committed, the transfer survives even a power failure.

Summary

  • A = Atomicity, C = Consistency, I = Isolation, D = Durability.
  • Together they make transactions reliable.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

WhatsApp