-
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock ?
1. 2-phase locking
2. Time-stamp ordering
-
- 1 only
- 2 only
- Both 1 and 2
- Neither 1 nor 2
- 1 only
Correct Option: B
Time stamp ordering ensures both conflict serializability and freedom from deadlock as timestamp-based concurrency control is a non-lock concurrency control method. The method is employed in relational databases to safely handle transactions. It uses the timestamps for the same.
