You have just had to restore from backup and do

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

141. You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.

(Continued on next question...)

Other Job Interview Questions

• A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
• What is a SQL * NET?
• What is the general guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
• How to implement the multiple control files for an existing database?
• What is the proper method for disabling and re-enabling a primary key constraint?
• A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?
• How to drop the index ?
• How do you resize a data file?
• What are the system resources that can be controlled through Profile?
• What is lexical reference?
• More...