Question

Which level of locking provides the highest degree of concurrency in a relational database?

Answer 1

Answer:

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.

Answer 2

$\bf \underline{\red{Answer}}$

• row share table lock

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.