MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 12 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
State true or false: We determine the serializability order of validation protocol by the validation ordering technique |
| A. | True |
| B. | False |
| Answer» C. | |
| 2. |
State true or false: Locking and timestamp ordering force a wait or rollback whenever a conflict is detected. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
STATE_TRUE_OR_FALSE:_LOCKING_AND_TIMESTAMP_ORDERING_FORCE_A_WAIT_OR_ROLLBACK_WHENEVER_A_CONFLICT_IS_DETECTED.?$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
State_true_or_false:_We_determine_the_serializability_order_of_validation_protocol_by_the_validation_ordering_technique$ |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
Which of the following timestamps is used to record the time when a database has completed its write operation? |
| A. | Start(i) |
| B. | Validation(i) |
| C. | Finish(i) |
| D. | Write(i) |
| Answer» D. Write(i) | |
| 6. |
Which of the following timestamps is used to record the time when a transaction has finished its read phase? |
| A. | Start(i) |
| B. | Validation(i) |
| C. | Finish(i) |
| D. | Write(i) |
| Answer» C. Finish(i) | |
| 7. |
Which of the following timestamp is used to record the time at which the transaction started execution? |
| A. | Start(i) |
| B. | Validation(i) |
| C. | Finish(i) |
| D. | Write(i) |
| Answer» B. Validation(i) | |
| 8. |
Read only operations omit the _______ phase |
| A. | Read phase |
| B. | Validation phase |
| C. | Write phase |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 9. |
During the _______ phase, the local variables that hold the write operations are copied to the database |
| A. | Read phase |
| B. | Validation phase |
| C. | Write phase |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 10. |
During the _________ phase the validation test is applied to the transaction |
| A. | Read phase |
| B. | Validation phase |
| C. | Write phase |
| D. | None of the mentioned |
| Answer» C. Write phase | |
| 11. |
During __________ phase, the system reads data and stores them in variables local to the transaction. |
| A. | Read phase |
| B. | Validation phase |
| C. | Write phase |
| D. | None of the mentioned |
| Answer» B. Validation phase | |
| 12. |
The _________ requires each transaction executes in two or three different phases in its lifetime |
| A. | Validation protocol |
| B. | Timestamp protocol |
| C. | Deadlock protocol |
| D. | View protocol |
| Answer» B. Timestamp protocol | |