MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
THE_DATABASE_IS_PARTITIONED_INTO_FIXED-LENGTH_STORAGE_UNITS_CALLED?$ |
| A. | Parts |
| B. | Blocks |
| C. | Reads |
| D. | Build |
| Answer» C. Reads | |
| 2. |
Which_of_the_following_causes_system_to_crash$ |
| A. | Bug in software |
| B. | Loss of volatile data |
| C. | Hardware malfunction |
| D. | All of the mentioned |
| Answer» E. | |
| 3. |
The failure occurred sufficiently early during the transfer that the destination block remains intact? |
| A. | Partial Failure |
| B. | Total failure |
| C. | Successful completion |
| D. | Data transfer failure |
| Answer» B. Total failure | |
| 4. |
Which kind of failure loses its data in head crash or failure during a transfer operation. |
| A. | Transaction failure |
| B. | System crash |
| C. | Disk failure |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 5. |
The assumption that hardware errors and bugs in the software bring the system to a halt, but do not corrupt the nonvolatile storage contents, is known as the |
| A. | Stop assumption |
| B. | Fail assumption |
| C. | Halt assumption |
| D. | Fail-stop assumption |
| Answer» E. | |
| 6. |
The transaction can no longer continue with its normal execution because of some internal condition, such as bad input, data not found, overflow, or resource limit exceeded. This is |
| A. | Read error |
| B. | Boot error |
| C. | Logical error |
| D. | System error |
| Answer» D. System error | |
| 7. |
The system has entered an undesirable state (for example, deadlock), as a result of which a transaction cannot continue with its normal execution. This is |
| A. | Read error |
| B. | Boot error |
| C. | Logical error |
| D. | System error |
| Answer» D. System error | |
| 8. |
Which of the following belongs to transaction failure |
| A. | Read error |
| B. | Boot error |
| C. | Logical error |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 9. |
Which one of the following is a failure to a system |
| A. | Boot crash |
| B. | Read failure |
| C. | Transaction failure |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 10. |
The recovery scheme must also provide |
| A. | High availability |
| B. | Low availability |
| C. | High reliability |
| D. | High durability |
| Answer» B. Low availability | |