Consider the following statements:
Statement 1: The two-phase locking protocol ensures conflict serializability and ensures freedom from deadlock.
Statement 2: With rigorous two-phase locking, transactions cannot be serialized in the order in which they commit.
Statement 3: Strict two-phase locking requires not only that locking is two-phase, but also that all exclusive-mode locks taken by a transaction be held until that transaction commits.
Which of the given statements is/are false?
1
Both S1 and S2
2
Both S1 and S3
3
Both S2 and S3
4
All S1, S2 and S3