Oracle Apps DBAs - What is difference between

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

(Continued from previous question...)

Oracle Apps DBAs - What is difference between shared APPL_TOP and shared Application Tier ?

- In shared APPL_TOP, only APPL_TOP & COMMON_TOP are shared across multiple middle tier where as in Shared Application Tier ORACLE_HOME (Middle Tier 806 & iAS directory) are also shared except configuration files (iAS).

(Continued on next question...)

Other Job Interview Questions

• ORACLE - What is Shared Application Tier ?
• Oracle Apps DBAs - How to create staging area
• Junior DBA’s - Do You Have a Basic Grasp of the Relational Model?
• Oracle Apps DBAs - How would you know about which servers are running on a particular node ?
• Oracle Apps DBAs - How would you know that your applications setup is a using shared APPL_TOP configuration ?
• Oracle Apps DBAs - When you install apps (11i/R12) it stores configuration in text file , what is name of this file and where is this stored ?
• I’m a developer. Explain why I need a unique key on my table.
• How do you plan for upgrades?
• SQL Server DBA - Solve the FizzBuzz problem with SQL code.
• ORACLE_HOM - Why do we get error when we run “opmnctl status” from ....
• More...