Chapter 19: Problem 4
How are buffering and caching techniques used by the recovery subsystem?
Chapter 19: Problem 4
How are buffering and caching techniques used by the recovery subsystem?
All the tools & learning materials you need for study success - in one app.
Get started for freeDiscuss the immediate update recovery technique in both single-user and multi user environments. What are the advantages and disadvantages of immediate update?
Describe the two-phase commit protocol for multidatabase transactions.
Choose the correct answer for each of the following multiple-choice questions: To cope with media (disk) failures, it is necessary a. for the DBMS to only execute transactions in a single user environment. b. to keep a redundant copy of the database. c. to never abort a transaction. d. all of the above.
What is the difference between the UNDO/REDO and the UNDO/NO-REDO algorithms for recovery with immediate update? Develop the outline for an UNDO/NOREDO algorithm.
Choose the correct answer for each of the following multiple-choice questions: For incremental logging with immediate updates, a log record for a transaction would contain: a. a transaction name, data item name, old value of item, new value of item. b. a transaction name, data item name, old value of item. c. a transaction name, data item name, new value of item. d. a transaction name and a data item name.
What do you think about this solution?
We value your feedback to improve our textbook solutions.