Failure Classification and Storage

Question 1
Marks : +2 | -2
Pass Ratio : 100%
The assumption that the hardware errors bring the system to a halt is called as ________
Halter assumption
Phantom assumption
Fail-stop assumption
Disk failure
Explanation:
The assumption that the hardware errors bring the system to a halt is called as fail-stop assumption. Well-designed systems have numerous internal checks that bring a system to a halt whenever there is an error. Hence, the fail stop assumption is a reasonable one.
Question 2
Marks : +2 | -2
Pass Ratio : 100%
Which of the following can cause a transaction failure
Logical error
System error
More than one of the mentioned
None of the mentioned
Explanation:
Logical errors and system errors are the two types of errors that can generally cause transaction failures.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
If a system has entered and undesirable state due to which it is unable to continue with normal execution, it is called as _________
Logical error
System error
System crash
None of the mentioned
Explanation:
If a system has entered and undesirable state due to which it is unable to continue with normal execution, it is called as a system error. The transaction however can be re-executed at a later time.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
The partitions of the database into fixed length storage units are called as __________
Blocks
Tuples
Relations
None of the mentioned
Explanation:
The database is partitioned into fixed length storage units called as blocks. Blocks are the units of data transfer and may contain several data items.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
If a failure has occurred in the midst of a transfer, it is called as _________
Successful completion
Partial failure
Total failure
None of the mentioned
Explanation:
If a failure has occurred in the midst of a transfer, it is called as partial failure. After a partial failure, the destination has incorrect information.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is not a classification of storage
Volatile storage
Nonvolatile storage
Stable storage
None of the mentioned
Explanation:
Volatile storage, non-volatile storage and stable storage are three different classifications of storage. Volatile storage is the least secure whereas stable storage is the most secure among them.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
The blocks residing on the disk are referred to as ___________
Physical blocks
Buffer blocks
Disk blocks
Disk buffer
Explanation:
The blocks residing on the disk are referred to as physical blocks. The blocks residing temporarily in the main memory are referred to as buffer blocks.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
If the transaction can no longer continue with its normal execution because of some internal condition, it is called as a _________
Logical error
System error
System crash
None of the mentioned
Explanation:
If the transaction can no longer continue with its normal execution because of some internal condition, it is called as a logical error such as bad input, data not found, overflow or resource limit exceeded.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
If there is a hardware malfunction or a bug in the database that causes the loss of content of volatile storage, it is called as ________
Logical error
System error
System crash
None of the mentioned
Explanation:
If there is a hardware malfunction or a bug in the database that causes the loss of content of volatile storage, it is called as a system crash. The data in the non-volatile storage remains intact and it is not corrupted.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
State true or false: The destination block has incorrect information in case of a total failure
True
False
Explanation:
In case of total failure, the failure occurs sufficiently early during the transfer that the destination block remains intact. Thus there is no corruption of data at the destination.