Question: When does a DBA use backward recovery? What does the DBMS do to perform backward recovery?

When does a DBA use backward recovery? What does the DBMS do to perform backward recovery?

Step by Step Solution

★★★★★

3.28 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

If a database has not been destroyed and transactions updated ... View full answer

blur-text-image
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)

Word file Icon

671-CS-DB (1021).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Q:

When does a DBA use forward recovery? What are the forward recovery steps?

Q:

Discuss how the log file (or journal) is a fundamental feature in any recovery mechanism. Explain what is meant by forward and backward recovery and describe how the log file is used in forward and...

Q:

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...

Q:

Review the advantages of database management systems in the Connolly textbook. Which two advantages do you think are the most important? Why? Give an example of a database or application you use that...

Q:

Question 1 Which of the following is NOT a function of a DBMS? Support data replication Provide catalog services Normalize the data Recover Data Question 2 The ability for a database to allow...

Q:

In each of the given scenario, a security measure has been used. Based on knowledge from the chapter, you have to identify which measure has been deployed and how: Backward recovery Forward...

Q:

Task 3: Analysis of shock wave A four-legged intersection, as shown in Figure 4, operates under a fixed time signal system. The phase diagram (Figure 5). phase timing data Table 3), intersection...

Q:

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...

Q:

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...

Q:

The DBA can enforce this policy by giving students permission to read only the Courseinfo view. Data availability and recovery from failures: The DBA must take steps to ensure that if the system...

Q:

A Reuters story (April 2, 2003) reported that The number of heart attack victims fell by almost 60% at one hospital six months after a smoke-free ordinance went into effect in the area (Helena,...

Q:

Which one of the following is the correct formula for EVA? a. Net operating profit before tax (Cost of capital Invested capital) b. Net operating profit after tax (Cost of capital Invested...

Q:

Problem 1 1 - 2 6 ( Algo ) Shutting Down or Continuing to Operate a Plant [ LO 1 1 - 2 ] Birch Company normally produces and sells 4 5 , 0 0 0 units of RG - 6 each month. The selling price is $ 2 0...

Q:

A corporation has $4,160,000 of common stock that pays a $3 dividend per share on a current market price of $40 per share. Assuming a 7 percent annual growth rate in the dividends, es- timate the...

Q:

Which of the following types of databases would most likely be used for tracking connections between people? a. Document b. Relational c. Graph d. Flat file

Q:

Why might distributed databases work extremely well for software version control projects but not so well for traditional transaction systems?

Q:

For the following exercises, you will answer problems and questions from management at JC Consulting. You do not need to use the JCConsulting database for any of these exercises. JC Consulting wants...

Q:

\ table [ [ Income , Current Year,Prior Year ] , [ Gross margin - with program payments, 2 2 2 . 8 0 0 , 2 8 6 . 0 0 0 ] , [ Gross margin - without program payments, 1 8 7 , 8 0 0 , 1 0 4 . 0 0 0 ] ,...

Q:

Problem 15-1 Integrating problem; bonds; note; lease [LO15-2] You are the new controller for Moonlight Bay Resorts. The company CFO has asked you to determine the companys interest expense for the...

Q:

describe some differences between a class and an interface.