Question

    What is the primary disadvantage of using a very restrictive locking protocol in a DBMS?

    A Deadlocks are more likely to occur. Correct Answer Incorrect Answer
    B Transaction throughput is reduced. Correct Answer Incorrect Answer
    C Data integrity is compromised. Correct Answer Incorrect Answer
    D It can lead to excessive resource contention. Correct Answer Incorrect Answer

    Solution

    It can lead to excessive resource contention.

    Practice Next

    Relevant for Exams:

    ×
    ×