Database Concepts (7th Edition)
7th Edition
ISBN: 9780133544626
Author: David M. Kroenke, David J. Auer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6, Problem 6.44RQ
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
Discuss the procedures for periodic back ups.
To what end does the system catalogue exist? Please list at least three products for which you have found information in the catalogue.
In what scenarios would denormalization be recommended, and what are its trade-offs?
Chapter 6 Solutions
Database Concepts (7th 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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- As of the time of writing, Damon Davis was completing out the paperwork for Drano Plumbing. He estimated a $50,000 net profit would be made. He counted the columns of the balance sheet and knew how much was in the credit column ($300,000) and how much was in the negative column ($400,000). What, in your opinion, was the most plausible reason for the discrepancy in the results? What should he do next to identify the issue's cause if this wasn't the cause of the issue?arrow_forwardNote: you must submit your work electronically through the system Answer the following questions in details: Q1) List and discuss Stop and wait ARQ and show how its drawbacks were resolved. Q2) List and discuss Selective repeat ARQ.arrow_forwardWhy should the procedure be flexible? What are they?arrow_forward
- Where does testing fit into BC/DR preparation? Can you tell me how many various tests there are?arrow_forwardDefine the terms error, fault, and failure. What exactly is a test oracle? What exactly is testing? Who does it, and why is it significant?arrow_forwardWhat is step-by-step testing? Please give a detailed answerarrow_forward
- Simplify explanation pleasearrow_forwardQUESTION 1 The OMCA club operations When members join OMCA health club, they pay a fee for a certain length of time. Most memberships are for 1 year, but memberships for short periods are available. Due to various promotions throughout the year, it is common for members to pay different amounts for the same length of membership. The club wants to e-mail reminders to members to ask them to renew their memberships one month before their memberships expire. Some members have been angry with staff when asked to renew at a much higher rate than their original membership contract. So, the club needs staff to keep track of the price paid so that the managers can override the regular prices with special prices when members are asked to renew. The system must keep track of these new prices so that renewals can be processed accurately. One of the problems in the health club industry is the high turnover rate of members. Although some members remain active for many years, about half of the…arrow_forwardDescribe the RAND report in detail. What was the holdup? Where did RAND Report R-609 put its emphasis?Which one make the most sense?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Management Of Information SecurityComputer ScienceISBN:9781337405713Author:WHITMAN, Michael.Publisher:Cengage Learning,
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L