Question

Which level of locking provides the highest degree of concurrency in a relational database ?
a) Page
b) Table
c) Row
d) Page, table and row level locking allow the same degree of concurrency

Answer 1

Row is a kind of level locking that offer the highest degree of concurrency in the relational database.

It is because there are various transactions can easily access various rows in the page / table at a time.

When it comes to serialisable and read committed transactions are using this kind of row-level locking.

Answer 2

Answer:

C) row

Explanation:

Row is a kind of level locking that offer the highest degree of concurrency in the relational database. It is because there are various transactions can easily access various rows in the page / table at a time.