ACID Properties MCQ Atomicity Consistency Isolation Durability Practice Questions

Direction: Choose the correct option

What does Atomicity mean in ACID?

A. All or nothing execution

B. Parallel execution

C. Partial execution

D. Fast execution

Direction: Choose the correct option

What does Consistency ensure?

A. Index usage

B. Database remains valid after transaction

C. Data duplication

D. Fast execution

Direction: Choose the correct option

What does Isolation prevent?

A. Slow queries

B. Index issues

C. Data loss

D. Concurrent transaction interference

Direction: Choose the correct option

What does Durability guarantee?

A. Index rebuild

B. Fast recovery

C. Committed data persists after crash

D. Data backup

Direction: Choose the correct option

What are isolation levels?

A. Transaction speeds

B. Index types

C. READ UNCOMMITTED, READ COMMITTED, etc.

D. Constraint levels

Quipoin Menu