Home » MCQs » DBMS MCQs » DBMS Lock-Based Protocol MCQs

Lock-based protocols ___ transactions if not all locks are granted, and they wait until all locks are granted until the transaction can continue

13. Lock-based protocols ___ transactions if not all locks are granted, and they wait until all locks are granted until the transaction can continue.

1. Abort
2. Commit
3. Rollback
4. End

Answer: C) Rollback

Explanation:

Lock-based protocols roll back transactions if not all locks are granted, and they wait until all locks are granted until the transaction can continue.