Question

N) ____ lock exists when concurrent transactions are granted read access on the basis of a common lock binary exclusive shared complete

Answer 1

shared lock

hope this helps

pls mark it as brainelist

Answer 2

Answer:

The answer is Shared lock.

Explanation:

Shared locks exist suitable when concurrent transactions exist granted READ access on the basis of a common lock because concurrent transactions founded on a READ cannot create a conflict. A shared lock exists issued when a transaction must read data from the database and no exclusive locks exist held on the data to be read.

• A shared lock is even called a read lock, used for reading data items only.
• Shared locks support read integrity. They provide that a record exists not in process of being updated during a read-only request.

Therefore, The answer is  Shared lock.

#SPJ2