Q)
Between the two concurrency control protocols: 2-phase locking and Time-stamp ordering, which protocol ensures both conflict serializability and freedom from deadlock? Give reasons
Q :-Between the two concurrency control protocols: 2-phase locking and Time-stamp ordering, which protocol ensures both conflict serializability and freedom from deadlock? Give reasons.
ANS - Tme -stamp ordering
Reason :- For example the time- stamp ordering is a non-lock concurrency regulator technique. It is used to securely handle transactions.
2-phase locking is a concurrency switch method that assurances serializability. The procedure uses locks, practical by a deal to information, which may block (understood as signs to halt) other transactions from retrieving the same data throughout the transaction’s lifetime.
Timestamp-based concurrency switch procedure is a non-lock concurrency switch technique. In Timestamp based technique, deadlock cannot happen as no deal always delays.
Get Answers For Free
Most questions answered within 1 hours.