Question

Which of the following types of locks permits other users access to unlocked portions of a table?

a) Exclusive lock
b) Shared lock
c) Read lock
d) Write lock

Answer 1

The correct answer is shared lock, which allows other users access to unlocked portions of a table while preventing modifications.

Step-by-step explanation:

The correct answer to the given question is b) Shared lock. A shared lock allows multiple users to access unlocked portions of a table simultaneously while preventing other users from modifying the data in those portions. It is commonly used in database management systems to ensure data integrity and concurrency control.

For example, imagine a scenario where several users need to read data from a table simultaneously without interfering with each other's operations. By applying a shared lock, users can access the data for reading purposes, and other users can also read the same data without any conflicts. However, if a user wants to modify the data, they would need an exclusive lock to ensure exclusive access during the modification process.