Home
Courses
About
School
Notes
Questions
MCQ
Contact
Vocational Courses
RDBMS
RDBMS
Failure Classification and Storage
Question 1
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 2
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 3
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 4
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 5
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 6
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 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%
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 9
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.
Question 10
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.
1
2
3
4
5
6
7
8
9
10
Time Left:
Submit
Score
:
Rank
:
Accuracy
:
%
Time
:
Total Question
:
Attempted
:
Correct
:
Wrong
:
User Name
Email Id
Mobile No
Submit