📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    Question

    Which concurrency anomaly is specific to phantom

    reads?
    A A record is updated by another transaction during read Correct Answer Incorrect Answer
    B A record disappears from a result set Correct Answer Incorrect Answer
    C A new record appears matching a query condition during re-execution Correct Answer Incorrect Answer
    D A record is read twice with different values Correct Answer Incorrect Answer
    E Index corruption occurs Correct Answer Incorrect Answer

    Solution

    Phantom read = a new row appears that wasn’t there in the first query because another transaction inserted it. Different from non-repeatable read (changed value).

    Practice Next
    More IT DBMS Questions
    ask-question