Which level of locking provides the highest degree of concurrency in a…
2004
Which level of locking provides the highest degree of concurrency in a relational data base?
- A.
Page
- B.
Table
- C.
Row
- D.
Page, table and row level locking allow the same degree of concurrency
Attempted by 164 students.
Show answer & explanation
Correct answer: C
To determine the highest degree of concurrency, consider the granularity of locking levels. Coarser locks (e.g., table or page) lock larger portions of data, reducing concurrency because more transactions are blocked. Finer locks (e.g., row-level) lock only individual rows, allowing more transactions to access different rows simultaneously. Row-level locking is the most granular, thus providing the highest degree of concurrency.