RDBMS Questions and Answers – Transaction Concept and Model

This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Transaction Concept and Model”.

1. Collections of operations that form a single logical unit of work are called __________
a) Views
b) Networks
c) Units
d) Transactions
View Answer

Answer: d
Explanation: Collections of operations that form a single logical unit of work are called transactions. A database system must ensure proper execution of transactions.

2. The “all-or-none” property is commonly referred to as _________
a) Isolation
b) Durability
c) Atomicity
d) None of the mentioned
View Answer

Answer: c
Explanation: The all or none policy is commonly referred to as atomicity. It ensures that a work is either completed or not completed and there are no intermediate stages.

3. Which of the following is a property of transactions?
a) Atomicity
b) Durability
c) Isolation
d) All of the mentioned
View Answer

Answer: d
Explanation: Atomicity, Durability and Isolation are all properties of transactions.
advertisement
advertisement

4. Execution of translation in isolation preserves the _________ of a database
a) Atomicity
b) Consistency
c) Durability
d) All of the mentioned
View Answer

Answer: b
Explanation: Execution of translation in isolation preserves the consistency of a database. It ensures that no other transaction is running concurrently.

5. Which of the following is not a property of a transaction?
a) Atomicity
b) Simplicity
c) Isolation
d) Durability
View Answer

Answer: b
Explanation: Simplicity is not a property of a transaction. Atomicity, Isolation, Durability are all parts of ACID properties.

6. Which of the following systems is responsible for ensuring durability?
a) Recovery system
b) Atomic system
c) Concurrency control system
d) Compiler system
View Answer

Answer: a
Explanation: The recovery system is responsible for the maintenance of durability. In addition, it also ensures atomicity.

7. Which of the following systems is responsible for ensuring isolation?
a) Recovery system
b) Atomic system
c) Concurrency control system
d) Compiler system
View Answer

Answer: c
Explanation: The concurrency control system is responsible for ensuring isolation in a database system.
advertisement

8. State true or false: Information residing in the volatile storage does not usually survive system crashes
a) True
b) False
View Answer

Answer: a
Explanation: Information residing in the volatile storage does not usually survive system crashes but the information in stable storage can survive system crashes efficiently.

9. A transaction that has not been completed successfully is called as _______
a) Compensating transaction
b) Aborted transaction
c) Active transaction
d) Partially committed transaction
View Answer

Answer: b
Explanation: Aborted transaction is a state after the transaction has been rolled back and the database has been restored to the state prior to the transaction.
advertisement

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

Answer: d
Explanation: Compensated is not a transaction state. But active, partially committed and failed are different states of a transaction.

11. The execution sequences in concurrency control are termed as ________
a) Serials
b) Schedules
c) Organizations
d) Time tables
View Answer

Answer: b
Explanation: The execution sequences in concurrency control are known as schedules.

12. The scheme that controls the interaction between executing transactions is called as _____
a) Concurrency control scheme
b) Multiprogramming scheme
c) Serialization scheme
d) Schedule scheme
View Answer

Answer: a
Explanation: The scheme that controls the interaction between executing transactions is called as concurrency control scheme.

Sanfoundry Global Education & Learning Series – RDBMS.

To practice all areas of RDBMS, here is complete set of 1000+ Multiple Choice Questions and Answers.

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.