Locking methods are one of the most common techniques
used in concurrency control. There are different levels of lock
use.
Make sure you clearly write down (a), (b) followed by
your answers.
[6 marks] (a) Use the following scenario to illustrate
and explain how a table-level lock and a page-level lock
work.
Scenario:
Transaction 1 (T1) wants to update row 5 in Table
A
Transaction 2 (T2) wants to update row 2 in Table
A
Note: Page 1 contains rows...