Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 6.45RQ
Program Plan Intro
Database recovery is the process of retrieving the data which was lost during the updating or deletion.
- It prepares the copy of the database and holds the data stored in the table (i.e save database).
- It also keeps a log of the transaction changes against the database since the save.
- If some failure occurs, the lost data can be retrieved using one of the two methods
- rollback
- rollforward
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
There are other methods available to stop the progress of a process, but "interrupt" and "traps"
are two of the most common.
Explain the distinctions between Interrupt and Trap, and provide some examples of each.
Is it feasible for one procedure to be interrupted while another is in the midst of
execution? Please explain your answers.
Draw the SRTF Gantt Chart for the following processes. Make sure your chart to include the time axis that shows the starting time and the ending time of each process.
Chapter 6 Solutions
Database Concepts (8th Edition)
Ch. 6 - Prob. 6.1RQCh. 6 - Explain how database administration tasks vary...Ch. 6 - Prob. 6.3RQCh. 6 - Prob. 6.4RQCh. 6 - Prob. 6.5RQCh. 6 - Prob. 6.6RQCh. 6 - Prob. 6.8RQCh. 6 - Prob. 6.9RQCh. 6 - Prob. 6.10RQCh. 6 - Prob. 6.11RQ
Ch. 6 - Prob. 6.12RQCh. 6 - Prob. 6.13RQCh. 6 - Prob. 6.14RQCh. 6 - Prob. 6.15RQCh. 6 - Prob. 6.16RQCh. 6 - Prob. 6.17RQCh. 6 - Prob. 6.18RQCh. 6 - Explain the benefits of marking transaction...Ch. 6 - Explain the use of the SQL transaction control...Ch. 6 - Prob. 6.21RQCh. 6 - Describe statement-level consistency.Ch. 6 - Prob. 6.23RQCh. 6 - Prob. 6.24RQCh. 6 - Prob. 6.25RQCh. 6 - Prob. 6.26RQCh. 6 - Prob. 6.27RQCh. 6 - Explain what serializable isolation level is. Give...Ch. 6 - Explain the term cursor.Ch. 6 - Prob. 6.30RQCh. 6 - What is the advantage of using different types of...Ch. 6 - Explain forward-only cursors. Give an example of...Ch. 6 - Explain static cursors. Give an example of their...Ch. 6 - Prob. 6.34RQCh. 6 - Prob. 6.36RQCh. 6 - Prob. 6.37RQCh. 6 - Describe the advantages and disadvantages of...Ch. 6 - Prob. 6.40RQCh. 6 - Prob. 6.41RQCh. 6 - Prob. 6.42RQCh. 6 - Prob. 6.44RQCh. 6 - Prob. 6.45RQCh. 6 - What is the advantage of making frequent...Ch. 6 - Summarize a DBAs responsibilities for managing...Ch. 6 - Prob. 6.48RQCh. 6 - Prob. 6.49RQCh. 6 - Prob. 6.50E
Knowledge Booster
Similar questions
- There are other methods available to stop the progress of a process, but "interrupt" and "traps" are two of the most common.Explain the distinctions between Interrupt and Trap, and provide some examples of each.arrow_forwardName different types of performance testingarrow_forwardThere are two methods for stopping processes and breaking deadlocks:arrow_forward
- Briefly explain process return codearrow_forwardWrite procedure steps involved in I/O simulater exercise of LogixPro PLC simulator along with screenshots. Also, write comments for each rung. Note: This Question is from LogixPro PLC simulator software.arrow_forwardThere are two techniques to stop processes and break deadlocks:arrow_forward
- Explain the role of the wait() process in terms of process termination in detail, using your own words as an example. Computer sciencearrow_forwardThere are two different approaches that may be used in order to end processes and release deadlocks.arrow_forwardExplain process ID in a few words.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education