Answer :

Answer:

A.

Explanation:

In computer science, the selection of a lockable device is an essential consideration in the creation of a database management system.

Granularity locking is a locking technique that is applied in database management systems (DBMS) as well as relational databases. The granularity of locks corresponds to how much data is locked at once, and it is determined when S lock (Shared Locks) are released.

The moment that S-locks are released will determine the granularity of locks (Option a).

  • A lock can be defined as a procedure capable of enforcing limits on access to a particular resource when there exist many threads of execution.

  • Multiple granularity locking (abbreviated as MGL) is a locking strategy employed in database management systems and also in relational databases.

  • This strategy (multiple granularity locking) is often used in order to ensure serializability.

In conclusion, the moment that S-locks are released will determine the granularity of locks (Option a).

Learn more in:

https://brainly.com/question/15691389

Other Questions