A

Admin • 802.91K Points
Coach

Q. Which isolation level prevents dirty reads but may allow non-repeatable reads and phantom reads?

  • (A) READ UNCOMMITTED
  • (B) READ COMMITTED
  • (C) REPEATABLE READ
  • (D) SERIALIZABLE
  • Correct Answer - Option(B)
  • Views: 1
  • Filed under category MySQL
  • Hashtags:
Explanation by: Admin
READ COMMITTED prevents dirty reads by reading only committed data but can allow non-repeatable reads and phantoms. READ UNCOMMITTED allows dirty reads. REPEATABLE READ prevents non-repeatable reads (MySQL's InnoDB uses next-key locking to avoid phantoms in many cases). SERIALIZABLE is the strictest and prevents these anomalies.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.