📢 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

    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

    Solution

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

    Practice Next
    ask-question