What is your Oracle application 11i Webserver Ve

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

(Continued from previous question...)

What is your Oracle application 11i Webserver Version and how to find it ?

From 11.5.8 to 11.5.10 Webserver version is iAS 1.0.2.2.2, In order to find version under $IAS_ORACLE_HOME/Apache/Apache/bin execute ./httpd -version
./httpd -version
Server version: Oracle HTTP Server Powered by Apache/1.3.19
Server built: Dec 6 2005 14:59:13 (iAS 1.0.2.2.2 rollup 5)

(Continued on next question...)

Other Job Interview Questions

• Where is DATABASE/PLSSQL cache stored ?
• How you put Applications 11i in Maintenance mode ?
• What are different modes of forms in which you can start Forms Server and which one is default ?
• Can a function take OUT parameters. If not why?
• What is an UTL_FILE? What are different procedures and functions associated with it?
• Can you use a commit statement within a database trigger?
• Where GWYUID defined and what is its used in Oracle Applications ?
• What is difference between Rename and Alias?
• Where is DATABASE/PLSSQL cache stored ?
• What are few profile options which you update after cloning ?
• More...