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

Question

Quizplus · Accepted Answer

A row-level lock allows concurrent transactions to access different rows of the same table without blocking each other. This means that multiple transactions can read and write to different rows of the same table at the same time, improving performance and concurrency. Table-level locks, on the other hand, would require all transactions to wait for one transaction to finish before accessing the table, which can lead to performance issues and decreased concurrency. Page-level locks would allow concurrent transactions to access different pages of the same table, but rows within the same page would still be locked and unavailable to other transactions.

A _____ Lock Allows Concurrent Transactions to Access Different Rows