Validation Based Protocols

Question 1
Marks : +2 | -2
Pass Ratio : 100%
State true or false: We determine the serializability order of validation protocol by the validation ordering technique
True
False
Explanation:
We determine the serializability order of the validation protocol by the timestamp ordering technique. There is no technique called as the validation ordering technique to determine the serializability order of the validation protocol.
Question 2
Marks : +2 | -2
Pass Ratio : 100%
Read only operations omit the _______ phase
Read phase
Validation phase
Write phase
None of the mentioned
Explanation:
Read only operations do not allow write operation to be performed on them. So, they omit the write phase but execute the read and validation phases.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
Which of the following timestamp is used to record the time at which the transaction started execution?
Start(i)
Validation(i)
Finish(i)
Write(i)
Explanation:
There are three different timestamps for each transaction start(i), validation(i), finish(i). Start(i) is used to record the time at which the transaction execution started.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
The _________ requires each transaction executes in two or three different phases in its lifetime
Validation protocol
Timestamp protocol
Deadlock protocol
View protocol
Explanation:
The validation protocol requires each transaction to execute in two or three different phases in its lifetime depending on whether it is a read only or an update transaction.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
Which of the following timestamps is used to record the time when a database has completed its write operation?
Start(i)
Validation(i)
Finish(i)
Write(i)
Explanation:
There are three different timestamps for each transaction start(i), validation(i), finish(i). Finish(i) is used to record the time when a transaction has finished its write phase.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
Which of the following timestamps is used to record the time when a transaction has finished its read phase?
Start(i)
Validation(i)
Finish(i)
Write(i)
Explanation:
There are three different timestamps for each transaction start(i), validation(i), finish(i). The validation phase is used to record the time at which a transaction has finished its read phase and has started its validation phase.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
During the _________ phase the validation test is applied to the transaction
Read phase
Validation phase
Write phase
None of the mentioned
Explanation:
During the validation phase, the validation test is applied to the transaction. This determines whether the transaction is allowed to proceed or not without causing a violation of serializability.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
State true or false: Locking and timestamp ordering force a wait or rollback whenever a conflict is detected.
True
False
Explanation:
Locking and timestamp ordering force a wait or rollback whenever a conflict is detected. This property is called pessimism of locking and timestamp protocols.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
During the _______ phase, the local variables that hold the write operations are copied to the database
Read phase
Validation phase
Write phase
None of the mentioned
Explanation:
During the write phase, the local variables that hold the write operations are copied to the database. Read only operations omit this phase.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
During __________ phase, the system reads data and stores them in variables local to the transaction.
Read phase
Validation phase
Write phase
None of the mentioned
Explanation:
During the read phase, the system reads data and stores them in variables local to the transaction. It performs all write operations on temporary local variables without updates on the actual database.