Oracle Apps DBAs - How would you know about wh

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 about which servers are running on a particular node ?

i) Check value of variable, isConc, isWeb, isForms, isAdmin in CONTEXT FILE
ii) Control scripts – only the services which are running from particular node will have the corresponding control scripts installed on that node (This answer is partially right, depending on AD & FND version).
iii) Check FND_NODES table

(Continued on next question...)

Other Job Interview Questions

• Why are you here?
• Oracle Apps DBAs - There are four Oracle Databases running on a mahine. How would you check the location of their Oracle Homes ?
• Oracle Apps DBAs - How would you know about which servers are running on a particular node ?
• How do you plan for upgrades?
• Oracle Apps DBAs - Adsplice –I have a 3 node installation: 1. Forms 2. Web 3. CM/Admin/Reports and DB which node I will run the adsplice on, to install a new product ?
• Oracle Apps DBAs - How would you know that your applications setup is a using shared APPL_TOP configuration ?
• Can you provide quality examples of your previous projects?
• If I asked you to learn how to make a query faster, what would you do?
• SQL Server - Explain why DBAs don’t like cursors.
• Oracle Apps DBAs - What is difference between shared APPL_TOP and shared Application Tier ?
• More...