Question

    In a DBMS using a "Strict Two-Phase Locking" protocol,

    when is a transaction allowed to release its locks?  
    A Only after it has acquired all the necessary locks Correct Answer Incorrect Answer
    B As soon as it acquires its first lock Correct Answer Incorrect Answer
    C At any point during its execution Correct Answer Incorrect Answer
    D Only after it has committed or aborted Correct Answer Incorrect Answer

    Solution

    Only after it has committed or aborted

    Practice Next

    Relevant for Exams: