How do you display console on a window?

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

(Continued from previous question...)

118. How do you display console on a window?

The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned. To specify that the console should be displayed, set the console window form property to the name of any window in the form. To include the console, set console window to Null.

(Continued on next question...)

Other Job Interview Questions

• What is schema?
• When do you use data parameter type?
• To view installed Oracle version information
• What are the two ways by which data can be generated for a parameters list of values?
• Is it possible to modify an external query in a report which contains it?
• Explain the use of TKPROF? What initialization parameter should be turned on to get full TKPROF output?
• What background process refreshes materialized views?
• What is a master detail relationship?
• What causes the "snapshot too old" error? How can this be prevented or mitigated?
• Auditing
• More...