Database Management MySQL Subjective
Oct 01, 2025

Explain ACID properties in database transactions.

Detailed Explanation

Atomicity: Transaction is all-or-nothing
Consistency: Database remains in valid state
Isolation: Concurrent transactions don't interfere
Durability: Committed changes are permanent

Example:
START TRANSACTION;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT; -- Both updates succeed or both fail

Discussion (0)

No comments yet. Be the first to share your thoughts!

Share Your Thoughts
Feedback