A lock locks the entire diskpage.
A)transaction-level
B)table-level
C)page-level
D)row-level

Question

Quizplus · Accepted Answer

A lock at page-level locks the entire diskpage, which is a coarser-grained lock as compared to row-level locking. This minimizes the number of locks needed for concurrency control, improving performance. However, this also increases the likelihood of conflicts and reduces concurrency. Table-level locking and transaction-level locking are too coarse-grained and fine-grained, respectively, for most practical scenarios.

A Lock Locks the Entire Diskpage