A _____ lock will lock the entire table, preventing access to any row by a transaction while another transaction is using the table.
A) database-level
B) table-level
C) page-level
D) row-level

Question

Quizplus · Accepted Answer

A table-level lock locks the entire table, preventing access to any row by a transaction while another transaction is using the table. This is the most restrictive type of lock and can cause concurrency issues. A database-level lock would lock the entire database, which is not necessary in this scenario. Page-level and row-level locks are less restrictive and would not prevent access to the entire table.

A _____ Lock Will Lock the Entire Table, Preventing Access