Database Questions and Answers – Transaction Atomicity and Durability

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
a) Aborted
b) Terminated
c) Closed
d) All of the mentioned
View Answer

Answer: a
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
a) Flashback
b) Rollback
c) Both Flashback and Rollback
d) Cannot be done
View Answer

Answer: d
Explanation: Once committed the changes cannot be rolled back.

3. Each modification done in database transaction are first recorded into the
a) Harddrive
b) Log
c) Disk
d) Datamart
View Answer

Answer: b
Explanation: After commit is issued the data are stored in a database and stored in drive.
advertisement
advertisement

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
View Answer

Answer: c
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
d) Edit.Exe
View Answer

Answer: c
Explanation: Transactions has to be managed by the executable files.
Note: Join free Sanfoundry classes at Telegram or Youtube

6. Which of the following is an atomic sequence of database actions?
a) Transaction
b) Concurrency
c) Relations
d) All of the mentioned
View Answer

Answer: a
Explanation: Transaction is a 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
View Answer

Answer: d
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 a consistent state.
advertisement

8. _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
a) Serializability
b) Atomicity
c) Isolation
d) Time stamping
View Answer

Answer: c
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
View Answer

Answer: a
Explanation: DBMS periodically suspends all processing and synchronizes its files and journals though the use of Check point facility.
advertisement

10. Which of the following is not a state in transaction?
a) Active
b) Terminated
c) Aborted
d) Partially committed
View Answer

Answer: b
Explanation: The transaction states are abort, active, committed, partially committed, Failed.

Sanfoundry Global Education & Learning Series – Database Management System.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.