You see the following on a status report: redo l

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

(Continued from previous question...)

You see the following on a status report: redo log space requests 23; redo log space wait time 0; Is this something to worry about? What if redo log space wait time is high? How can you fix this?

Level: Intermediate
Expected answer: Since the wait time is zero, no. If the wait time was high it might indicate a need for more or larger redo logs.

(Continued on next question...)

Other Job Interview Questions

• What does COMMIT do?
• What are the steps involved in Database Shutdown?
• How can a button be used in a report to give a drill down facility?
• Explain UNION, MINUS, UNION ALL and INTERSECT?
• What type of index should you use on a fact table?
• What is Execution Plan?
• Can you pass data parameters to forms?
• Where in the Oracle directory tree structure are audit traces placed?
• What is a Private Synonyms?
• You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
• More...