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.

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

\n

💻 Live Code Editor

Is page ki language (MYSQL) mein code likhein aur turant chalाएं — yahीं, bina kuch install kiye.
Powered by OneCompiler. Agar editor na khule to yahान naye tab mein kholein.

💻 Live Code Editor

Is page ke program yahan ready hain — chalाएं, badlें aur seekhें. Bina kuch install kiye.
Powered by OneCompiler. Editor mein code apne aap aa jata hai — Run dabaakर output dekhें. Agar load na ho to naye tab mein kholें.