ORACLE - What is Shared Application Tier ?

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

(Continued from previous question...)

ORACLE - What is Shared Application Tier ?

Sharing Application Tier ( including APPL_TOP, COMN_TOP, ORA_TOP) across all Middle Tier Nodes in configuration is called as Shared Application Tier.

Shared APPL_TOP is subset of shared Application Tier , initially shared APPL_TOP came out & based on its advantages & popularity later COMMON_TOP & ORA_TOP files were also included & entire concept is called as Shared Application Tier.

(Continued on next question...)

Other Job Interview Questions

• Oracle Apps DBAs - How would you check if the tablespace is in backup mode ?
• A project manager needs a new SQL Server. What do you ask her?
• SQL Server - Explain referential integrity and where it can be enforced.
• Why are you here?
• Why do You Want to be a DBA?
• What’s the Largest Database You’ve Worked With?
• For Junior DBA’s - Do You Know The Primary Responsibility of a DBA?
• Oracle Apps DBAs - What is port pool ?
• How can you tell if a query will scale for production?
• A project manager needs a new SQL Server. What do you ask her?
• More...