Series: Subject: Topic:
Question: 31 of 89

Two Phase Locking Protocol

Explain the concept of two phase locking protocol with an example?
Asked by: veerun14 | Member Since Sep-2008 | Asked on: Sep 24th, 2008

View all questions by veerun14   View all answers by veerun14

Showing Answers 1 - 2 of 2 Answers

Answered On : Dec 8th, 2008

View all answers by rpeters83

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.

Login to rate this answer.

Answered On : Apr 15th, 2009

View all answers by dhs01

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).   

Login to rate this answer.

Give your answer:

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

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.