Shared Locks In Database

Shared Locks In Database: Shared Locks are also called Read Locks. When shared lock is applied by a transaction, other user of transaction can read data but not update the locked records. Shared locks are applied in case when you want to open same records for reading such that no other user changes these records during this time. Other transaction can also apply shared locks but no exclusive locks on these records.

Record Locking In Database

Record Locking In Database Record Locking In Database: Record Locking mechanism is the most common method to implement the concurrency control in DBMS. Locking means record or set of records…

Continue Reading Record Locking In Database