A lock allows concurrent transactions to access different rows of the same table.
A)database-level
B)table-level
C)page-level
D)row-level

Question

Quizplus · Accepted Answer

Row-level locking is the most fine-grained level of locking, as it allows concurrent transactions to access different rows of the same table. This means that while one transaction is accessing or modifying one row, another transaction can access or modify a different row in the same table without being blocked. Table-level and page-level locking are less fine-grained and can lead to more blocking and contention. Database-level locking is the most coarse-grained level of locking and should be avoided as much as possible, as it can cause significant performance issues in a multi-user environment.

A Lock Allows Concurrent Transactions to Access Different Rows of the Same