MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 18 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The scheme that controls the interaction between executing transactions is called as _____ |
| A. | Concurrency control scheme |
| B. | Multiprogramming scheme |
| C. | Serialization scheme |
| D. | Schedule scheme |
| Answer» B. Multiprogramming scheme | |
| 2. |
The execution sequences in concurrency control are termed as ________ |
| A. | Serials |
| B. | Schedules |
| C. | Organizations |
| D. | Time tables |
| Answer» C. Organizations | |
| 3. |
Which of the following is not a transaction state? |
| A. | Active |
| B. | Partially committed |
| C. | Failed |
| D. | Compensated |
| Answer» E. | |
| 4. |
A transaction that has not been completed successfully is called as _______ |
| A. | Compensating transaction |
| B. | Aborted transaction |
| C. | Active transaction |
| D. | Partially committed transaction |
| Answer» C. Active transaction | |
| 5. |
State true or false: Information residing in the volatile storage does not usually survive system crashes |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
The “all-or-none” property is commonly referred to as _________ |
| A. | Isolation |
| B. | Durability |
| C. | Atomicity |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 7. |
A_TRANSACTION_THAT_HAS_NOT_BEEN_COMPLETED_SUCCESSFULLY_IS_CALLED_AS________?$ |
| A. | Compensating transaction |
| B. | Aborted transaction |
| C. | Active transaction |
| D. | Partially committed transaction |
| Answer» C. Active transaction | |
| 8. |
The execution sequences in concurrency control are termed as ________$ |
| A. | Serials |
| B. | Schedules |
| C. | Organizations |
| D. | Time tables |
| Answer» C. Organizations | |
| 9. |
Which_of_the_following_is_not_a_transaction_state?$ |
| A. | Active |
| B. | Partially committed |
| C. | Failed |
| D. | Compensated |
| Answer» E. | |
| 10. |
The_scheme_that_controls_the_interaction_between_executing_transactions_is_called_as______ |
| A. | Concurrency control scheme |
| B. | Multiprogramming scheme |
| C. | Serialization scheme |
| D. | Schedule scheme |
| Answer» B. Multiprogramming scheme | |
| 11. |
State true or false: Information residing in the volatile storage does not usually survive system crashe? |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
Which of the following systems is responsible for ensuring isolation? |
| A. | Recovery system |
| B. | Atomic system |
| C. | Concurrency control system |
| D. | Compiler system |
| Answer» D. Compiler system | |
| 13. |
Which of the following systems is responsible for ensuring durability? |
| A. | Recovery system |
| B. | Atomic system |
| C. | Concurrency control system |
| D. | Compiler system |
| Answer» B. Atomic system | |
| 14. |
Which of the following is not a property of a transaction? |
| A. | Atomicity |
| B. | Simplicity |
| C. | Isolation |
| D. | Durability |
| Answer» C. Isolation | |
| 15. |
Execution of translation in isolation preserves the _________ of a database |
| A. | Atomicity |
| B. | Consistency |
| C. | Durability |
| D. | All of the mentioned |
| Answer» C. Durability | |
| 16. |
Which of the following is a property of transactions? |
| A. | Atomicity |
| B. | Durability |
| C. | Isolation |
| D. | All of the mentioned |
| Answer» E. | |
| 17. |
The “all-or-none” property is commonly referred to as _________$ |
| A. | Isolation |
| B. | Durability |
| C. | Atomicity |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 18. |
Collections of operations that form a single logical unit of work are called __________ |
| A. | Views |
| B. | Networks |
| C. | Units |
| D. | Transactions |
| Answer» E. | |