Q37
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
AnswerAnswer: Option B
Solution
Answer: Option B
Solution:
Phantom read does not refer to modifications or deletions of existing rows.
It occurs when a transaction reads a set of rows that satisfy a condition, and then, upon re-execution of the same query, finds additional rows (phantoms) that were inserted by another committed transaction.
This is different from non-repeatable reads, where a transaction rereads data and finds that it has been modified or deleted by another transaction.
Therefore, the statement given in the question describes a non-repeatable read, not a phantom read.