Two Phase Locking Protocol

Explain the concept of two phase locking protocol with an example?

Questions by veerun14   answers by veerun14

Showing Answers 1 - 2 of 2 Answers


  • Dec 8th, 2008

I'm no DB admin but I'll give it a shot. It's a protocol gauranteed to allow serialized actions on a database by having a locking phase and an unlocking phase. Meaning, during locking, no other transactions may be performed on the database until it is unlocked.

  Was this answer useful?  Yes


  • Apr 15th, 2009

Not sure of the particular terminology but 2 phase locking I believe would be similar to 2 phase commit where you must first make sure that everybody involved is ready, able, and willing (phase 1) then the next phase is when it actually happens (phase 2).   

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions