RDBMS

Transaction Concept and Model

Question 1
Marks : +2 | -2
Pass Ratio : 100%
The “all-or-none” property is commonly referred to as _________
Isolation
Durability
Atomicity
None of the mentioned
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.
Question 2
Marks : +2 | -2
Pass Ratio : 100%
Collections of operations that form a single logical unit of work are called __________
Views
Networks
Units
Transactions
Explanation:
Collections of operations that form a single logical unit of work are called transactions. A database system must ensure proper execution of transactions.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
Which of the following systems is responsible for ensuring durability?
Recovery system
Atomic system
Concurrency control system
Compiler system
Explanation:
The recovery system is responsible for the maintenance of durability. In addition, it also ensures atomicity.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
A transaction that has not been completed successfully is called as _______
Compensating transaction
Aborted transaction
Active transaction
Partially committed transaction
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.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is not a transaction state?
Active
Partially committed
Failed
Compensated
Explanation:
Compensated is not a transaction state. But active, partially committed and failed are different states of a transaction.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
Which of the following systems is responsible for ensuring isolation?
Recovery system
Atomic system
Concurrency control system
Compiler system
Explanation:
The concurrency control system is responsible for ensuring isolation in a database system.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is a property of transactions?
Atomicity
Durability
Isolation
All of the mentioned
Explanation:
Atomicity, Durability and Isolation are all properties of transactions.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
State true or false: Information residing in the volatile storage does not usually survive system crashes
True
False
Explanation:
Information residing in the volatile storage does not usually survive system crashes but the information in stable storage can survive system crashes efficiently.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
Execution of translation in isolation preserves the _________ of a database
Atomicity
Consistency
Durability
All of the mentioned
Explanation:
Execution of translation in isolation preserves the consistency of a database. It ensures that no other transaction is running concurrently.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is not a property of a transaction?
Atomicity
Simplicity
Isolation
Durability
Explanation:
Simplicity is not a property of a transaction. Atomicity, Isolation, Durability are all parts of ACID properties.