๐Ÿ“ข Too many exams? Donโ€™t know which one suits you best? Book Your Free Expert ๐Ÿ‘‰ call Now!

  • google app store apple app store
  • โœ–

      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
      ask-question