Answer-Phantom Reads occur when:

Phantom new rows addedremoved by another transaction affect results.

Question

Phantom Reads occur

when:

A A transaction reads dirty data Correct Answer Incorrect Answer

B Rows appear/disappear between two queries in the same transaction Correct Answer Incorrect Answer

C A transaction overwrites committed data Correct Answer Incorrect Answer

D Deadlock occurs Correct Answer Incorrect Answer

E Index is corrupted Correct Answer Incorrect Answer

Phantom = new rows added/removed by another transaction affect results.

Practice Next

More IT DBMS Questions

Thank You for posting your query. Please check your email for further guidance

Please Register/Login to Download Question