Database Questions and Answers – Failure Classification

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Failure Classification”.

1. The recovery scheme must also provide
a) High availability
b) Low availability
c) High reliability
d) High durability
View Answer

Answer: a
Explanation: It must minimize the time for which the database is not usable after a failure.

2. 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
View Answer

Answer: c
Explanation: Types of system failure are transaction failure, system crash and disk failure.

3. Which of the following belongs to transaction failure
a) Read error
b) Boot error
c) Logical error
d) All of the mentioned
View Answer

Answer: c
Explanation: Types of system transaction failure are logical and system error.
advertisement
advertisement

4. 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
View Answer

Answer: d
Explanation: The transaction, can be re-executed at a later time.

5. 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
View Answer

Answer: c
Explanation: The transaction, can be re-executed at a later time.
Note: Join free Sanfoundry classes at Telegram or Youtube

6. 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
View Answer

Answer: d
Explanation: Well-designed systems have numerous internal checks, at the hardware and the software level, that bring the system to a halt when there is an error. Hence, the fail-stop assumption is a reasonable one.

7. 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
View Answer

Answer: c
Explanation: Copies of the data on other disks, or archival backups on tertiary media, such as DVD or tapes, are used to recover from the failure.
advertisement

8. 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
View Answer

Answer: a
Explanation: Copies of the data on other disks, or archival backups on tertiary media, such as DVD or tapes, are used to recover from the failure.

9. The database is partitioned into fixed-length storage units called
a) Parts
b) Blocks
c) Reads
d) Build
View Answer

Answer: b
Explanation: Blocks are the units of data transfer to and from disk, and may contain several data items.
advertisement

10. 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
View Answer

Answer: d
Explanation: The content of non-volatile storage remains intact, and is not corrupted.

Sanfoundry Global Education & Learning Series – Database Management System.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.