Interview Question

What is ACID property?

ACID describes core transaction reliability properties.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

ACID summarizes atomicity, consistency, isolation, and durability properties of transactions. • Atomicity treats a transaction as an all-or-nothing unit. • Isolation controls interaction between concurrent transactions. • Durability means committed results survive later failures within the database guarantees.

💡 SQL Example

BEGIN; INSERT INTO orders (order_id, customer_id) VALUES (100, 1); COMMIT;

Result

COMMIT

⚡ Quick Revision

ACID describes core transaction reliability properties.