Give an example of a schedule in which a pessimistic concurrency control makes a transaction wait but then allows it to commit, while an optimistic concurrency control allows the transaction to commit without waiting.
What will be an ideal response?
The following schedule would be accepted by an optimistic control.
r1(x) r2(y) w1(z ) w2(z ) commit1 commit2
A pessimistic control would force the operation w2(z ) to wait.
Computer Science & Information Technology
You might also like to view...
A(n) ________ document contains instructions for displaying its contents in a web browser
A) Access 2010 B) Word 2010 C) RTF D) HTML
Computer Science & Information Technology
Having used the Color gallery to change the color of a graphic, with the graphic selected, click ____ in the Color gallery to change a graphic back to its original color.
A. No Recolor B. Restore C. Revert D. Default Color
Computer Science & Information Technology