There are lot of DBC file under $FND_SECURE, How

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

(Continued from previous question...)

There are lot of DBC file under $FND_SECURE, How its determined that which dbc file to use from $FND_SECURE ?

This value is determined from profile option "Applicationss Database ID"

(Continued on next question...)

Other Job Interview Questions

• What is difference between Rename and Alias?
• How to compile Invalid Objects in database ?
• What is FNDSM ?
• What is a cursor for loop?
• What are different modes of parameters used in functions and procedures?
• Where GWYUID defined and what is its used in Oracle Applications ?
• What is difference between ADPATCH and OPATCH ?
• Where is Concurrent Manager log file location.
• What is a pseudo column. Give some examples?
• How to check if Oracle application 11i System is Rapid Clone enabled ?
• More...