How to implement the multiple control files for

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

(Continued from previous question...)

424. How to implement the multiple control files for an existing database?

1. Shutdown the database
2. Copy one of the existing control file to new location
3. Edit Config ora file by adding new control filename
4. Restart the database.

(Continued on next question...)

Other Job Interview Questions

• How do you reference a parameter indirectly?
• Why is a Where clause faster than a group filter or a format trigger?
• What are different types of images?
• What is Log Switch?
• Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?
• What is the “LOV of Validation” Property of an item? - What is the use of it?
• What is a profile?
• What are the default extensions of the files created by library module?
• Logical DB Structure
• What causes the "snapshot too old" error? How can this be prevented or mitigated?
• More...