📢 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

    Distributed 2-Phase Commit (2PC) can suffer

    from:
    A Lost update anomaly Correct Answer Incorrect Answer
    B Coordinator failure blocking all participants Correct Answer Incorrect Answer
    C Phantom reads Correct Answer Incorrect Answer
    D Index inconsistency Correct Answer Incorrect Answer
    E Write skew Correct Answer Incorrect Answer

    Solution

    If coordinator crashes after “prepare” but before “commit,” participants may block.

    Practice Next
    More IT DBMS Questions
    ask-question