Oracle Scenarios Question:
Download Questions PDF

Explain If the entire disk is corrupted how will you and what are the steps to recover the database?

Answer:

if the entire disk is corrupted and no backup is there don nothing sit and relax their is no possibility of recovery ...a backup is required for restoration and for recovery redo log and archive logs.

Once if you have theses than think of recovering ..a dba should always plan for the recovery scenario depending upon the criticality of the database.oracle provides 0% data loss facilty through data guard and online backup .its dba who has to decide.

Download Oracle Scenarios Interview Questions And Answers PDF

Previous QuestionNext Question
Schema A has some objects and created one procedure and granted to Schema B.
Schema B has the same objects like schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B?		If All the users are complaining that their application is hanging. How we will resolve this situation in OLTP?