Failure Classification - DBMS Questions and Answers

1.

Which of the following belongs to transaction failure

   A.) Read error
   B.) Boot error
   C.) Logical error
   D.) All of the mentioned

Answer: Option 'C'

Types of system transaction failure are logical and system error.

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: Option 'D'

The content of non-volatile storage remains intact, and is not corrupted.

3.

The recovery scheme must also provide

   A.) High availability
   B.) Low availability
   C.) High reliability
   D.) High durability

Answer: Option 'A'

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

4.

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: Option 'D'

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.

5.

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: Option 'C'

Types of system failure are transaction failure, system crash and disk failure.

Failure Classification - DBMS Questions and Answers Download Pdf