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

Solution (By Examveda Team)

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.