Home »
MCQs »
DBMS MCQs
DBMS Failure Classification MCQs
DBMS Failure Classification MCQs: This section contains multiple-choice questions and answers on Failure Classification in DBMS.
Submitted by Anushree Goswami, on April 18, 2022
1. We categorize failures into the following categories so that we can identify where the problem lies:
- Transaction Failure
- Disk Failure
- System Crash
- All of the above
Answer: D) All of the above
Explanation:
We categorize failures into the following categories so that we can identify where the problem lies:
- Transaction Failure
- Disk Failure
- System Crash
Discuss this Question
2. Transactions fail when they either ___ to execute or reach a point at which they cannot proceed.
- Pass
- Fail
- Run
- Stop
Answer: B) Fail
Explanation:
Transactions fail when they either fail to execute or reach a point at which they cannot proceed.
Discuss this Question
3. A transaction ___ occurs when a process or transaction is harmed.
- Success
- Failure
- Harmful
- Search
Answer: B) Failure
Explanation:
A transaction failure occurs when a process or transaction is harmed.
Discuss this Question
4. Transactions may fail for the following reasons:
- Logical Errors
- Syntax Error
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Transactions may fail for the following reasons:
- Logical Errors
- Syntax Error
Discuss this Question
5. The _____ error occurs when there is a code error or internal error condition that prevents a transaction from completing.
- Logical
- Syntax
- Data
- Code
Answer: A) Logical
Explanation:
The logical error occurs when there is a code error or internal error condition that prevents a transaction from completing.
Discuss this Question
6. If the database system is not able to execute an ___ transaction, the DBMS itself terminates it.
- Active
- Inactive
- Empty
- Full
Answer: A) Active
Explanation:
If the database system is not able to execute an active transaction, the DBMS itself terminates it.
Discuss this Question
7. In the event of a deadlock or unavailability of resources, an active transaction is ___.
- Committed
- Rollbacked
- Aborted
- Sent
Answer: C) Aborted
Explanation:
In the event of a deadlock or unavailability of resources, an active transaction is aborted.
Discuss this Question
8. In addition to power failures, ___ failures can cause system failures.
- Hardware
- Software
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
In addition to power failures, hardware or software failures can cause system failures.
Discuss this Question
9. System crashes typically do not corrupt ___ storage.
- Volatile
- Non-volatile
- Crash
- System
Answer: A) Volatile
Explanation:
System crashes typically do not corrupt nonvolatile storage.
Discuss this Question
10. Frequent mechanical failures are caused by ___.
- Hard drives
- Storage drives
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Frequent mechanical failures are caused by hard drives or storage drives.
Discuss this Question
11. What are the causes for disk failure, which destroy the entire disk or part of it?
- Bad sectors
- Head crashes
- Unreachable disks
- All of the above
Answer: D) All of the above
Explanation:
There are many causes for disk failure, including bad sectors, head crashes, and unreachable disks, which destroy the entire disk or part of it.
Discuss this Question