What is new_form built-in?

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

(Continued from previous question...)

101. What is new_form built-in?

When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new form calling new form completely replace the first with the second. If there are changes pending in the first form, the operator will be prompted to save them before the new form is loaded.

(Continued on next question...)

Other Job Interview Questions

• To view installed Oracle version information
• What is a SQL * NET?
• Why is it preferable to create a fewer no. of queries in the data model?
• What are the steps involved in Database Startup?
• What type of index should you use on a fact table?
• Where in the Oracle directory tree structure are audit traces placed?
• What is forms_DDL?
• If a parameter is used in a query without being previously defined, what diff. exist between report 2.0 and 2.5 when the query is applied?
• Describe what redo logs are.
• 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?
• More...