Home »
MCQs »
DBMS MCQs
DBMS Validation Based Protocol MCQs
DBMS Validation Based Protocol MCQs: This section contains multiple-choice questions and answers on Validation Based Protocol in DBMS.
Submitted by Anushree Goswami, on April 19, 2022
1. What is the Validation Phase also known as?
- Optimistic Concurrency Control Technique
- Optimistic Consecutive Control Technique
- Pessimistic Concurrency Control Technique
- Pessimistic Consecutive Control Technique
Answer: A) Optimistic Concurrency Control Technique
Explanation:
Validation Phase is also known as Optimistic Concurrency Control Technique.
Discuss this Question
2. In how many phases is the transaction executed in the validation-based protocol?
- 2
- 3
- 4
- 5
Answer: B) 3
Explanation:
In 3 phases the transaction is executed in the validation based protocol.
Discuss this Question
3. What are the three phases in which the transaction is executed in the validation-based protocol?
- Read phase
- Validation phase
- Write phase
- All of the above
Answer: D) All of the above
Explanation:
The three phases in which the transaction is executed in the validation-based protocols are -
- Read phase
- Validation phase
- Write phase
Discuss this Question
4. What happens in the read phase?
- Transaction is read
- Transaction is executed
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
In read phase -
- Transaction is read
- Transaction is executed
Discuss this Question
5. Data items are read in and stored in ___ using this function.
- Temporary Global Variables
- Temporary Local Variables
- Permanent Global Variables
- Permanent Local Variables
Answer: B) Temporary Local Variables
Explanation:
Data items are read in and stored in temporary local variables using this function.
Discuss this Question
6. You don't need to update the actual database for all the writes on temporary variables in the___ phase.
- Read
- Validate
- Write
- None
Answer: A) Read
Explanation:
Data items are read in and stored in temporary local variables using this function.
Discuss this Question
7. ___ temporary variable values against actual data is a requirement for the validation phase.
- Reading
- Writing
- Validating
- Updating
Answer: C) Validating
Explanation:
Validating temporary variable values against actual data is a requirement for the validation phase.
Discuss this Question
8. In the Write phase, the temporary results of the transaction are written to the database or system if the validation of the transaction is successful or else the ___ of the transaction is performed.
- Abort
- Rollback
- Commit
- End
Answer: B) Rollback
Explanation:
In the Write phase, the temporary results of the transaction are written to the database or system if the validation of the transaction is successful or else the rollback of the transaction is performed.
Discuss this Question
9. What is the Timestamp in the Read Phase?
- Start (Ti)
- Read (Ti)
- Execute (Ti)
- Write (Ti)
Answer: A) Start (Ti)
Explanation:
Start (Ti) is the timestamp in the read phase.
Discuss this Question
10. The beginning of the ___ of Ti is represented by Start (Ti).
- Abort
- Commit
- Rollback
- Execution
Answer: D) Execution
Explanation:
The beginning of the execution of Ti is represented by Start (Ti).
Discuss this Question
11. In validation (Ti) it is the number of seconds since Ti completed its read phase and began its ___ phase.
- Write
- Finish
- Validation
- Start
Answer: C) Validation
Explanation:
In validation (Ti) it is the number of seconds since Ti completed its read phase and began its validation phase.
Discuss this Question
12. What is the timestamp in the Write phase?
- Start (Ti)
- Validation (Ti)
- Write (Ti)
- Finish (Ti)
Answer: D) Finish (Ti)
Explanation:
Finish (Ti) is the timestamp in the Write phase.
Discuss this Question
13. The Finish (Ti) value indicates when Ti completed its ____ phase.
- Read
- Write
- Finish
- Validation
Answer: B) Write
Explanation:
The Finish (Ti) value indicates when Ti completed its write phase.
Discuss this Question
14. With this protocol, a time stamp is determined for each transaction based on the timestamp of the ___ phase, since it is the ___ phase that determines whether or not the transaction will be committed.
- Read
- Write
- Validation
- Finish
Answer: C) Validation
Explanation:
With this protocol, a time stamp is determined for each transaction based on the timestamp of the validation phase, since it is the validation phase that determines whether or not the transaction will commit.
Discuss this Question
15. During ___, the serializability of a data set is determined.
- Read
- Validation
- Write
- None
Answer: B) Validation
Explanation:
During validation, the serializability of a data set is determined.
Discuss this Question
16. It ensures ___ when executing the transaction.
- Greater Concurrency
- Fewer Conflicts
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
It ensures greater concurrency and fewer conflicts when executing the transaction.
Discuss this Question
17. Transactions with fewer ___ are included in this protocol.
- Rollbacks
- Commits
- Aborts
- Beginnings
Answer: A) Rollbacks
Explanation:
Transactions with fewer rollbacks are included in it.
Discuss this Question