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

How to repair a corrupt firebird database?

0 Answers  


Explain what are the two types of oltp?

0 Answers  


Enlist the advantages of normalizing database.

0 Answers  


How does distributed database work?

0 Answers  


What is concurrency control?

0 Answers  






Can A column defined as PRIMARY KEY can have NULL values ?

2 Answers  


Explain the importance of partitioning.

0 Answers  


If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?

2 Answers  


How do I create a database in access 2010?

0 Answers  


1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

0 Answers   Cap Gemini,


can Constraints cannot be exported through EXPORT command ?

2 Answers   Grasim, Oracle, Suvidha,


What are queries in dbms?

0 Answers  






Categories