Question 3
Marks : +2 | -2
Pass Ratio : 100%
In timestamp ordering protocol, suppose that the transaction Ti issues read(Q) and TS(Ti)<W-timestamp(Q), then
Explanation: Suppose that transaction Ti issues read(Q). If TS(Ti ) < W-timestamp(Q), then Ti needs to read a value of Q that was already overwritten. Hence, the read operation is rejected, and Ti is rolled back.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
A ________ ensures that any conflicting read and write operations are executed in timestamp order
Explanation: A timestamp ordering protocol ensures that any conflicting read and write operations are executed in timestamp order.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
Explanation: W-timestamp(Q) denotes The largest timestamp of any transaction that can execute write(Q) successfully.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
Explanation: R-timestamp(Q) denoted the largest timestamp of any transaction that can execute read(Q) successfully.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
In timestamp ordering protocol, suppose that the transaction Ti issues write(Q) and TS(Ti)<W-timestamp(Q), then
Explanation: In timestamp ordering protocol, suppose that the transaction Ti issues write(Q) and TS(Ti)<W-timestamp(Q), then the value of Q that Ti is producing was needed previously, and the system assumed that the value would never be produced. Hence the system rejects the write(Q) operation and the transaction Ti rolls back.