What is the use of Control File?

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

(Continued from previous question...)

151. What is the use of Control File?

When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.

(Continued on next question...)

Other Job Interview Questions

• What is the proper method for disabling and re-enabling a primary key constraint?
• What are the built -ins used for Modifying a groups structure?
• What view would you use to determine free space in a tablespace?
• If the DEFAULT and TEMPORARY tablespace clauses are left out of a CREATE USER command what happens? Is this bad or good? Why?
• How can you enable automatic archiving?
• What is ROWID?
• What are Clusters?
• Does a Before form trigger fire when the parameter form is suppressed?
• Schema
• What is strip sources generate options?
• More...