Which of the following types of locks permits other users access to unlocked portions of a table?
A) shared lock
B) table lock
C) exclusive lock
D) partition lock

Question

Which of the following types of locks permits other users access to unlocked portions of a table?
A) ​shared lock
B) ​table lock
C) ​exclusive lock
D) ​partition lock

Quizplus · Accepted Answer

A shared lock allows other users to access unlocked portions of a table. It is often used in situations where multiple users need to access a table simultaneously, but modifications are not permitted until the lock is released. Table locks and exclusive locks, on the other hand, do not allow other users to access the table until the lock is released, and partition locks pertains to a specific portion of a table, rather than allowing access to unlocked portions.

Which of the Following Types of Locks Permits Other Users