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?

Answer: C. RowTo determine the highest degree of concurrency, consider the granularity of locking levels. Coarser locks (e.g., table or page) lock larger portions of data,…

  1. A.

    Page

  2. B.

    Table

  3. C.

    Row

  4. D.

    Page, table and row level locking allow the same degree of concurrency

Attempted by 251 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.

Explore the full course: Iocl Engineers Officers Grade A Paper 2

Loading lesson…