Question
1) What are binary locks? 2) What are exclusive/shared locks? How do they insure more concurrency? 3) What is lock escalation? Give an example. 4)
1) What are binary locks? 2) What are exclusive/shared locks? How do they insure more concurrency? 3) What is lock escalation? Give an example. 4) What is the 2 phase locking protocol? Why is it important 5) What is conservative 2 phase locking? Are there any drawbacks? 6) What is strict 2 phase locking? Are there any drawbacks? 7) Discuss one of the examples of 2 phase locking given in the slides. How does it assure that the resulting changes to the database are correct?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Excel 2024 In 7 Days
Authors: Alan Dinkins
1st Edition
B0CJ3X98XK, 979-8861224000
