Describe the basic steps involved in recovery, Database Management System

Question:

One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known as recovery.

(a) Describe the three basic steps involved in recovery.

(b) Describe the three types of failure in a database system. Support your answer with appropriate example.

(c) Explain in details how you would recover from all the three types of the failure described above.

Posted Date: 11/16/2013 2:53:50 AM | Location : United States







Related Discussions:- Describe the basic steps involved in recovery, Assignment Help, Ask Question on Describe the basic steps involved in recovery, Get Answer, Expert's Help, Describe the basic steps involved in recovery Discussions

Write discussion on Describe the basic steps involved in recovery
Your posts are moderated
Related Questions
Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

how to implement hyrise in C plus plus

List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

State the terms Designing the database and Normalization Designing the database: Out of the ERD we have formed, it is very easy to verify the tables, the attributes which the

What is meant by functional dependencies? Consider a relation schema R and α C R and β C R. The functional dependency α ->β  holds on relational schema R if in any legal relati

Describe the four main ways of optimising disk block access. Ans: a. Disk  b. Non-volatile writes buffers c. File organization (Clustering) d. Log-based file system

List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization

properties of derirable decomposition

What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on

#questiontypes of keys examples..