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

Discussion

SERIALIZABLE is the strictest isolation level.

  • A.True
  • B.False

Answer: A

Correct answer: True

Serializable permits none of the three anomalies - no dirty reads, no nonrepeatable reads and no phantoms - and gives a result equivalent to running the transactions one at a time. It achieves the last of these by locking key ranges as well as rows, which is what blocks the insertion that would otherwise produce a phantom.

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

Post your comment

Please log in or register to post a comment.