ACID properties in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the 'A' in ACID stand for in database transactions?

The 'A' stands for Atomicity. It means a transaction is all or nothing: either all steps complete successfully, or none do.

beginner

Explain Consistency in ACID properties.

Consistency means a transaction must bring the database from one valid state to another, following all rules like constraints and triggers.

intermediate

What does Isolation ensure in database transactions?

Isolation ensures that concurrent transactions do not interfere with each other. Each transaction behaves as if it runs alone.

beginner

Define Durability in the context of ACID.

Durability means once a transaction is committed, its changes are permanent, even if the system crashes immediately after.

beginner

Why are ACID properties important in databases?

ACID properties keep data accurate and reliable by ensuring transactions are complete, consistent, isolated, and permanent.

Which ACID property guarantees that a transaction is fully completed or not done at all?

A Isolation

B Consistency

C Atomicity

D Durability

Atomicity means the transaction is all or nothing.

Which property ensures that database rules are not broken after a transaction?

A Consistency

B Atomicity

C Isolation

D Durability

Consistency ensures the database stays valid after transactions.

What does Isolation prevent in concurrent transactions?

A Data loss

B System crashes

C Slow queries

D Interference between transactions

Isolation keeps transactions from affecting each other.

Durability means that after a transaction commits, its changes are:

A Lost on crash

B Permanent

C Temporary

D Reversible

Durability guarantees changes stay even after crashes.

Which ACID property is about making sure a transaction behaves as if it runs alone?

A Isolation

B Atomicity

C Durability

D Consistency

Isolation means transactions do not see each other's partial changes.

Describe all four ACID properties and why each is important for database transactions.

Think about what happens if a transaction partially completes or if multiple transactions run at the same time.

Give a real-life example that illustrates the need for ACID properties in a banking system.

Imagine sending money from one account to another.