GATE | GATE-IT-2004 | Question 21
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
Answer: (C)
Explanation:
- 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