Wednesday 27 January 2016

Oracle Apps DBA Interview Questions




              ARCHITECTURE RELATED QUESTIONS
Q)  What is session time out parameter & where all you define     these values?

Q)  How to determine Oracle Apps 11i Version?
 
Q)  What is your Oracle Apps 11i Webserver Version and how to find it ?            
 
Q)  What is forms server executable Name?
 
Q)  What is forms client executable Name?
 
Q)  How to check number of forms users at any time ?
 
Q)  What are different modes of forms in which you can start Forms Server and which one is default ?
 
Q)  Where is HTML Cache stored in Oracle Apps Server?
 
Q)  How will you find Invalid Objects in database ?
 
Q)  What is make program in Unix?
 
Q)  How can u change the log files location suppose CM log file location is APPLCSF
 
Q)  Conflict resolution managers resolves the conflicts yes, but hw it knows that there are conflicts ? why conflicts occur?
 
Q)  What is adovars.env file ?
 
Q)  Whats main concurrent Manager types.
 
Q)  Why should Apps & Applsys passwords always be the same ?
 
Q)  Explain Architecture of Oracle Apps 11i.
 
Q)  What are various components in Application/Middle Tier.   
 
Q)  Where is Concurrent Manager log file location.
 
Q)  Where is applications start/stop scripts stored ?
 
Q)  What are main configuration files in Web Server (Apache)?
 
Q)  What is use of Apps listener ?
 
Q)  How to start Apps listener ?
 
Q)  Whats is difference between two env files in <CONTEXT_NAME>.env and APPS<CONTEXT_NAME>.env under $APPL_TOP ?
 
Q)  How to confirm if Report Server is Up & Running ?
 
Q)  How to confirm if Apps Listener is Up & Running ?
 
Q)  Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored & why its used ?
 
Q)  What is .dbc file, where its stored, what’s use of .dbc file?


====================================================================================

             HOW TO FIND THE VERSIONS OF EBS COMPONENTS


1): How to find Forms Version in 11i ?
2): How to find Forms Version in Apps from command Line ?
3): How to find Jinitiator Version ?
4): How to find Version of any file in Oracle Apps 11i ?
5): How to find Operation System Version (Unix/Linux) ?
6): How to find if your Operating System is 32 bit or 64 Bit ?
7): Can I run 64 bit application on 32 bit Operating system ?
 
8) How to find if your database is 32 bit or 64 bit(Useful in applying Patches) ?
 
9): How to find OUI version ?
10): How to find Database version ?
11): How to find Oracle Workflow Cartridge Release Version ?
12): Determining the Current Version of OJSP ?
13): How to find opatch Version ?
14): How to find Version of Apps 11i ?
15): How to Discoverer Version installed with Apps ?
16): How to find Workflow Version embedded in Apps 11i ?
17): How to find version of JDK Installed on Apps ?
18): How to find out version of a package ?
19):How to find the database/sqlplus version?
      Ans : select banner from v$version;
20):How to find out what are the languages enabled in u r        applications?
     Ans : Query fnd_languages



Thanks
Srini

No comments:

Post a Comment


No one has ever become poor by giving