Explain two phase locking protocol with example in dbms
Answers
Answered by
2
Hey Mate
control method which divides the execution phase of a transaction into three parts.
It ensures conflict serializable schedules.
If read and write operations introduce the first unlock operation in the transaction, then it is said to be Two-Phase Locking Protocol.
This protocol can be divided into two phases,
1. In Growing Phase, a transaction obtains locks, but may not release any lock.
2. In Shrinking Phase, a transaction may release locks, but may not obtain any lock.
Two-Phase Locking does not ensure freedom from deadlocks.
hope this answer helps you
please mark it as brainliest
control method which divides the execution phase of a transaction into three parts.
It ensures conflict serializable schedules.
If read and write operations introduce the first unlock operation in the transaction, then it is said to be Two-Phase Locking Protocol.
This protocol can be divided into two phases,
1. In Growing Phase, a transaction obtains locks, but may not release any lock.
2. In Shrinking Phase, a transaction may release locks, but may not obtain any lock.
Two-Phase Locking does not ensure freedom from deadlocks.
hope this answer helps you
please mark it as brainliest
Similar questions