Which of the following is not true about locks?
A)Locks with large granularity are easier for the DBMS to administer.
B)Locks with small granularity cause more conflicts.
C)Locks may have a database-level granularity.
D)Locks may have a table-level granularity.

Question

Quizplus · Accepted Answer

Locks with small granularity (such as row-level locks) actually lead to fewer conflicts because they allow more transactions to access different parts of the data concurrently. Larger granularity locks (such as table-level locks) are more restrictive and can lead to more conflicts because they prevent access to the entire table even if different transactions are accessing different rows.

Which of the Following Is Not True About Locks