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

    Question

    Which of the following concurrency control methods

    avoids deadlocks entirely but can reduce concurrency by blocking transactions at start?
    A Two-phase locking (2PL) with deadlock detection Correct Answer Incorrect Answer
    B Timestamps ordering protocol (e.g., Thomas’ write rule) Correct Answer Incorrect Answer
    C Strict 2PL with wait-die/wound-wait Correct Answer Incorrect Answer
    D Conservative (static) 2PL — acquire all locks before execution Correct Answer Incorrect Answer
    E Optimistic concurrency control with validation Correct Answer Incorrect Answer

    Solution

    Conservative 2PL prevents deadlocks by ensuring a transaction obtains all required locks before proceeding; if not available, it waits or aborts, reducing concurrency.

    Practice Next
    More IT DBMS Questions
    ask-question