This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Transaction Atomicity and Durability”.
1. A transaction may not always complete its execution successfully. Such a transaction is termed
d) All of the mentioned
Explanation: If we are to ensure the atomicity property, an aborted transaction must have no effect on the state of the database.
2. If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
c) Both Flashback and Rollback
d) Cannot be done
Explanation: Once committed the changes cannot be rolled back.
3. Each modification done in database transaction are first recorded into the
Explanation: After commit is issued the data are stored in database and stored in drive.
4. When the transaction finishes the final statement the transaction enters into
a) Active state
b) Committed state
c) Partially committed state
d) Abort state
Explanation: The commit statement has to be issued to enter into committed state.
5. The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called
a) Batch. Exe
b) Trans. Exe
c) Opt. Exe
Explanation: Transactions has to be managed by the executable files.
6. Which of the following is an atomic sequence of database actions?
d) All of the mentioned
Explanation: Transactions is collection of operations that provides single logical function in database.
7. If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
a) Consistent state
b) Parallel state
c) Atomic state
d) Inconsistent state
Explanation: If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called in consistent state.
8. _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
d) Time stamping
Explanation: Isolation means that data used during the execution of a transaction can’t be used by a second transaction until the first one is completed.
9. DBMS periodically suspends all processing and synchronizes its files and journals through the use of
a) Checkpoint facility
b) Backup facility
c) Recovery manager
d) Database change log
Explanation: DBMS periodically suspends all processing and synchronizes its files and journals though the use of Check point facility.
10. Which of the following is not a state in transaction ?
d) Partially committed
Explanation: The transaction states are abort,active,committed,partially committed, Failed.
Sanfoundry Global Education & Learning Series – Database Management System.