What are shared locks in database management?

What are shared locks in database management?

Shared locks allow multiple transactions to read a resource without modifying it, ensuring data consistency.

How do shared locks differ from exclusive locks?

Exclusive locks prevent other transactions from accessing the resource, while shared locks allow concurrent reads.

Can you give me an example of when to use a shared lock?

You would use a shared lock when multiple users need to read data simultaneously, like in a reporting scenario.

What happens if a transaction holds a shared lock?

If a transaction holds a shared lock, other transactions can also acquire shared locks but cannot obtain exclusive locks.