Concept
Phantom Reads 0
Phantom reads occur in database systems when a transaction reads a set of rows that satisfy a certain condition, and a subsequent read within the same transaction returns additional rows due to another transaction inserting new rows that meet the condition. This phenomenon is a result of concurrency and can be mitigated by using higher isolation levels like Serializable to ensure consistency.
Relevant Degrees