Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are the steps involved in Instance Recovery ?



What are the steps involved in Instance Recovery ?..

Answer / guest

Rolling forward to recover data that has not been recorded
in data files, yet has been recorded in the on-line redo
log, including the contents of rollback segments.

Rolling back transactions that have been explicitly rolled
back or have not been committed as indicated by the rollback
segments regenerated in step a.
Releasing any resources (locks) held by transactions in
process at the time of the failure.

Resolving any pending distributed transactions
undergoing a two-phase commit at the time of the instance
failure.

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More Database Management Interview Questions

what is s/w lifecycle?

1 Answers   IBM,


What is data redundancy in dbms?

0 Answers  


What is the most used database?

0 Answers  


How many number of columns can a RECORD GROUP have ?

0 Answers  


What is 'cross join'? Or what is cartesian product?

0 Answers  






What is the type of image in database?

0 Answers  


Enlist various transaction phases.

0 Answers  


What is Distributed database ?

2 Answers  


What are the features of dbms?

0 Answers  


How is a database related to a table?

0 Answers  


What is a relation schema?

0 Answers  


How to migrate paradox, dbase or foxpro database to firebird?

0 Answers  


Categories