Machine-translated by Google. Questions are authored in English.
Top

Discussion

Dirty read, nonrepeatable, and phantom reads are not possible in this instance.

  • A.Read committed
  • B.Read uncommitted
  • C.Repeatable read
  • D.Serializable

Answer: D

Correct answer: Serializable

Serializable is the strictest level and permits none of the three anomalies: no dirty reads, no nonrepeatable reads and no phantoms. It gives the same result as running the transactions one after another, which is where the name comes from. The cost is the concurrency given up to achieve it, which is why lower levels exist at all.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.