Home »
MCQs »
DBMS MCQs
DBMS States of Transaction MCQs
DBMS States of Transaction MCQs: This section contains multiple-choice questions and answers on states of transaction in DBMS.
Submitted by Anushree Goswami, on April 10, 2022
1. In how many states can a transaction be?
- 4
- 5
- 6
- 7
Answer: B) 5
Explanation:
States of transaction are 5.
Discuss this Question
2. Which of the following is NOT a state of Transaction?
- Begin
- End
- Partially Aborted
- Terminated
Answer: C) Partially Aborted
Explanation:
Partially Aborted is NOT a state of transaction.
Discuss this Question
3. Which of the following is the first state of every transaction?
- Active
- Failed
- Aborted
- Committed
Answer: A) Active
Explanation:
The first state of every transaction is Active.
Discuss this Question
4. Which of the following functionality can be performed in the active state?
- Insertion
- Updation
- Deletion
- All of the above
Answer: D) All of the above
Explanation:
The following functionality can be performed in the active state -
- Insertion
- Updation
- Deletion
Discuss this Question
5. In which of the following states, the data is still not saved in the database?
- Active
- Partially Committed
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
In Active & Partially Committed states, the data is still not saved in the database.
Discuss this Question
6. In which of the following states, the transaction executes its final operation?
- Active
- Partially Committed
- Aborted
- Failed
Answer: C) Partially Committed
Explanation:
In the Partially Committed state, the transaction executes its final operation.
Discuss this Question
7. What is TRUE about Committed state of the transaction?
- The transaction executes its final operation
- Data is still not saved to the database
- All the effects are temporarily saved in the database
- None of the above
Answer: D) None of the above
Explanation:
None of the above statements are true about the committed state of the transaction.
Discuss this Question
8. When a transaction executes all its operations successfully, it is said to be in a ___ state.
- Partially Committed
- Failed
- Aborted
- Committed
Answer: D) Committed
Explanation:
When a transaction executes all its operations successfully, it is said to be in a committed state.
Discuss this Question
9. The ___ state means that the effects have been saved permanently in the database.
- Committed
- Partially Committed
- Active
- Aborted
Answer: A) Committed
Explanation:
The committed state means that the effects have been saved permanently in the database.
Discuss this Question
10. The transaction is said to be in the ___ state if any of the checks made by the database recovery system fail.
- Aborted
- Committed
- Failed
- End
Answer: C) Failed
Explanation:
The transaction is said to be in the failed state if any of the checks made by the database recovery system fail.
Discuss this Question
11. The database recovery system ensures that the database is back to its ___ if any of the checkpoints fail and the transaction reaches a failed state.
- Previous Consistent state
- Post Consistent State
- Inconsistent State
- None of the above
Answer: A) Previous Consistent state
Explanation:
The database recovery system ensures that the database is back to its previous consistent state if any of the checkpoints fail and the transaction reaches a failed state.
Discuss this Question
12. The transaction will ___ if the database state is not consistent after the last transaction.
- Abort
- Rollback
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
The transaction will abort or rollback if the database state is not consistent after the last transaction.
Discuss this Question
13. The state of all executed transactions is restored to its consistent state if the transaction fails in the ___.
- Beginning
- End
- Middle
- None of the above
Answer: C) Middle
Explanation:
The state of all executed transactions is restored to its consistent state if the transaction fails in the middle.
Discuss this Question
14. Database recovery module will choose an operation from the ___ options after aborting the transaction.
- 2
- 3
- 4
- 5
Answer: A) 2
Explanation:
Database recovery module will choose an operation from the 2 options after aborting the transaction.
Discuss this Question
15. What are the two available operations for the database recovery module after aborting the transaction?
- Re-start the transaction
- Kill the transaction
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
The two available operations for the database recovery module after aborting the transaction are re-start the transaction and kill the transaction.
- Abort
- Commit
Discuss this Question
16. Which of the following is a state of transaction?
- Begin
- End
- Aborted
- Terminated
Answer: C) Aborted
Explanation:
Aborted is a state of transaction.
Discuss this Question