A lock locks 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 lock that locks the entire table and prevents access to any row by a transaction is a table-level lock. This means that when a transaction acquires a lock on a table, no other transaction can read, write or modify the data in that table until the lock is released. Table-level locks are the most restrictive type of locks and are not recommended for use in highly concurrent systems.

A Lock Locks the Entire Table Preventing Access to Any