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