Advanced
Database Management Systems
Q83 / 100
What is lock escalation in databases?
Correct! Well done.
Incorrect.
The correct answer is B) The database automatically converting many fine-grained locks (row locks) to coarser-grained locks (page or table locks) to reduce lock overhead when too many locks are held
B
Correct Answer
The database automatically converting many fine-grained locks (row locks) to coarser-grained locks (page or table locks) to reduce lock overhead when too many locks are held
Explanation
Lock escalation trades fine-grained concurrency for lower memory overhead. SQL Server escalates to table locks after ~5,000 row locks. Can cause unexpected blocking; disable per-table when problematic.
Progress
83/100