Question discussion

Which SQL isolation level prevents dirty reads but still allows non-repeatable reads?

2166Medium DSSSB TGT Computer Science 0 replies

Which SQL isolation level prevents dirty reads but still allows non-repeatable reads?

  • AREAD UNCOMMITTED
  • BREAD COMMITTED
  • CREPEATABLE READ
  • DSERIALIZABLE
Correct answer: B

Explanation

READ COMMITTED lets a transaction see only committed data (no dirty reads), but a row read twice may change between reads; REPEATABLE READ and SERIALIZABLE forbid that.

Discussion 0

Nobody has replied yet. Start the discussion!