Question

Diffrence between shared lock and exclusive lock in DBMS

Answer 1

difference between shared lock and exclusive lock in dbms

Binary Locks − A lock on a data item can be in two states; it is either locked or unlocked. Shared/exclusive − This type of locking mechanism differentiates the locks based on their uses. If a lock is acquired on a data item to perform a write operation, it is an exclusive lock.

Answer 2

Difference between a shared lock and exclusive lock in DBMS is given below:-

Explanation:

Shared lock

• Each transaction gets a mutual lock on the details, and a shared lock is also given once the second transaction demands the same data.
• Shared keys last as long as they have to last; it relies on the stage of the agreement that holds the lock.
• A shared lock is essentially a line-level read-only lock.

Exclusive lock

• The Exclusive Lock is used and valid for a transaction, locking either a row or a page depending on the details.
• The mechanism of understanding is clear, where an unlimited lock can only be applied to a single node.
• Exclusive or compose lock gives the process exclusive access to the defined part of the file to be written.

Learn more:-

brainly.in/question/9792042