engineering computer science MCQ #635

Which locking mechanism is used to prevent deadlocks?

engineering computer science MCQ #635

  1. Question 1

    Q1. Which locking mechanism is used to prevent deadlocks?

    • A) Two-phase locking
    • B) One-phase locking
    • C) Optimistic concurrency control
    • D) Pessimistic concurrency control

    Answer: Two-phase locking

    Explanation: Two-phase locking is a concurrency control mechanism that prevents deadlocks by acquiring all locks before releasing any, ensuring transaction consistency.