Oracle Apps DBAs - How would you know that you

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

(Continued from previous question...)

Oracle Apps DBAs - How would you know that your applications setup is a using shared APPL_TOP configuration ?

- If you apply a patch, it should be visible on all nodes (APPL_TOP) which are part of shared APPL_TOP configuration.
- Since APPL_TOP is on a shared disk, create file in APPL_TOP from one node, it should be visible from other nodes.
To Know more on shared APPL_TOP check metalink note
243880.1 Shared APPL_TOP FAQ
384248.1 Sharing The Application Tier File System in Oracle E-Business Suite Release 12
233428.1 Sharing the Application Tier File System in Oracle Applications 11i

(Continued on next question...)

Other Job Interview Questions

• A project manager needs a new SQL Server. What do you ask her?
• What trends do you see coming in the next 3 years that will impact your role the most?
• How do you plan for upgrades?
• Oracle Apps DBAs - How would you know that your applications setup is a using shared APPL_TOP configuration ?
• SQL Server - What is the difference between a primary key and a clustered index?
• Which is faster: Inserting one million rows of data, or updating one million rows of data?
• Junior DBA’s - Do You Have Any Goals?
• 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 ?
• ORACLE_HOM - What is INST_TOP in Oracle Apps ?
• Who is the most important user of a database?
• More...