Chapter 9 Transaction Management MCQs

19 min Score: 0 Attempted: 0/19 Subscribe
1. Durability can be ensured in ______ ways.





2. Performing concurrent execution of transactions reduces





3. When a transaction is rolled back and entered at the aborted stage, the available system's options are of





4. The usage of concurrent execution of transactions improves





5. Atomicity is ensured by a component of the database called the





6. A transaction is said to be a unit of program's





7. A single transaction failure may result into a set of transaction rollbacks, is known to be





8. Transactions access data using operations of





9. Serializability of schedules can be ensured through a mechanism called





10. Schedules should preferably be





11. Ensuring durability is the responsibility of





12. The effects of a committed transaction can be undo by executing a





13. Examples of nonvolatile storage are magnetic disks and





14. A schedule can be tested against the conflict serializability by constructing





15. When the changes made by the aborted transaction has been undone, the transaction is said to be





16. The term stating either all operations of the transaction to be displayed at the database, or none at all is known to be





17. Stable storage that can be accessed online is approximated with





18. A transaction must be in one of the states from





19. By finding a linear order consistent with the partial order in the precedence graph, we can obtain the





Contents Copyrights Reserved By T4Tutorials