Tech_Interview_Prep

Transactions & Isolation Levels

ACID guarantees, and the isolation-level trade-off between correctness and concurrent throughput.

Q1.What does the "A" in ACID stand for, and what does it guarantee?

Q2.What is a "dirty read"?

Q3.Which standard isolation level prevents dirty reads and non-repeatable reads, but can still allow phantom reads?

Q4.What isolation level provides the strongest guarantees, making concurrent transactions behave as if executed one at a time?