Question

The isolation level that prevents dirty reads but allows non-repeatable reads is _______ .

• A. read uncommitted
• B. read committed
• C. repeatable read
• D. serializable

Hint:

"Read committed" is commonly used for general purpose transactions as it avoids dirty reads but still allows some concurrency anomalies like non-repeatable reads.

Answer 1

The Correct Option is B

The "read committed" isolation level prevents dirty reads, meaning no uncommitted data is read. However, it allows non-repeatable reads, as the data can change between reads.