Question: Five recovery techniques are listed below. For each situation described, decide which of the following recovery techniques is most appropriate. Backward recovery Forward

Five recovery techniques are listed below. For each situation described, decide which of the following recovery techniques is most appropriate.

• Backward recovery

• Forward recovery (from latest checkpoint)

• Forward recovery (using backup copy of database)

• Reprocessing transactions

• Switch

a. A phone disconnection occurs while a user is entering a transaction.

b. A disk drive fails during regular operations.

c. A lightning storm causes a power failure.

d. An incorrect amount is entered and posted for a student tuition payment. The error is not discovered for several weeks.

e. Data entry clerks have entered transactions for two hours after a full database backup when the database becomes corrupted. It is discovered that the journalizing facility of the database has not been activated since the backup was made.

Step by Step Solution

★★★★★

3.30 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Aborted transaction use backward recovery Of course the transaction then needs to be reentered b D... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

613-CS-DB (2046).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Which of the following strategies do you think IT executives should adopt to improve their current situation: reject new projects, attempt to increase staff and funding, prioritize often, or all of...

During the Sarbanes-Oxley audit of a financial services company, you note the following issues. Categorize each of them into the area to which they belong: IT change management, logical access to...

Examine the two applications shown in Figures 8-9a and 8-9b. Identify the various security considerations that are relevant to each environment.? (a) Static page request Web Server Application Server...

Five recovery techniques are listed below. For each situation described, decide which of the following recovery techniques is most appropriate. Backward recovery Forward recovery (from latest...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

1 WILMINGTON UNIVERSITY LIBRARY Business Continuity Plan (BCP) and Disaster Recovery Plan (DRP) 2 WILMU LIBRARY SERVICES 20,000 student population served 13 physical locations of access to university...

Please answer this question.. Very easy. -What sources of value most plausibly account for the differences between buyer and seller? -Structure and execute a discounted cash flow valuation of all of...

Please do these questions: -What sources of value most plausibly account for the differences between buyer and seller? -Structure and execute a discounted cash flow valuation of all of the MW...

Students should read the given case Nissan Motor Company Ltd.: Building Operational Resiliency and address the following tasks: Q3. Analyze operational risk management measures and develop a solution...

Four entrepreneurial students want to open a shaved ice business during the coming summer. First student thinks that demand will be high; second feels strongly that demand will be low and the third...

Based on the material in the case and the chapter content, how would you describe Mark Wilson's personality?

Question content area top Part 1 Which of the following would be best considered to be an agency conflict problem in the behavior of the following financial managers? Question content area bottom...

What do you think Eminems incentive is to give a free show? Was his decision made in selfinterest or in the social interest? Explain your answer.

Describe the concept of full functional dependency and describe how this concept relates to 2NF. Provide an example to illustrate your answer.

Describe the concept of transitive dependency and describe how this concept relates to 3NF. Provide an example to illustrate your answer.

Discuss how the definitions of 2NF and 3NF based on primary keys differ from the general definitions of 2NF and 3NF. Provide an example to illustrate your answer.

x Y Z Corporation is considering acquiring ABC Company. x Y Z estimates that the acquisition will generate additional free cash flows of 1 . 2 million dollars per year, in perpetuity. XYZ...

Jasper Furnishings has $350 million in sales. The company expects that its sales will increase 13% this year. Jasper's CFO uses a simple linear regression to forecast the company's inventory level...

SOLVE EXCEL PLEASE 2. Brandon buys a piece of equipment for $15,000. He pays $5,000 for upgrades in year 1 and the equipment generates $2,000 in cash flow for year 1 . In year 2 the equipment...