Which level of locking provides the highest degree of concurrency in a relational data base?
(D) Page, table and row level locking allow the same degree of concurrency
- Page level locking locks whole page i.e all rows therefore highly restrictive
- Table locking is mainly used for concurrency control with DDL operations
- A row share table lock is the least restrictive, and has the highest degree of concurrency for a table.It indicates the transaction has locked rows in the table and intends to update them.
Therefore, Row level provides highest level of concurrency. Option (C) is correct.
Quiz of this Question