πŸ“’ Too many exams? Don’t know which one suits you best? Book Your Free Expert πŸ‘‰ call Now!


    ⚑ Month End Offer - Flat 52% Off On All Courses! Enroll Now ⚑
    00:00:00 AM Left

    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
    ask-question