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

Discussion

A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

  • A.True
  • B.False

Answer: B

Correct answer: False

What is described is a nonrepeatable read: rows already seen have been modified or deleted by a committed transaction. A phantom read is the appearance of new rows that were not there before. The distinction decides which isolation level is needed, since repeatable read prevents the first but not the second.

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

Post your comment

Please log in or register to post a comment.