Consider the following statements and choose the incorrect statements:
I – Rigours 2PL has the property that for two conflicting transactions, their commit order is their serializability order.
II – Most of the concurrency protocols are based on view serializability.

(A) I
(B) II
(C) Both I and II
(D) Neither I Nor II


Answer: (C)

Explanation: I -Rigorous two-phase locking has the advantages of strict 2PL. In addition, it has the property that for two conflicting transactions, their commit order is their serializability order.
II – Most of the concurrency protocols are based on conflict serializability not on view serializability because of costlier nature of view serializability.
So, option (C) is correct.

Quiz of this Question