Oracle Apps 11i DBA Interview Questions

My Favourites

If you want to submit any technical questions for oracle apps 11i which might be helpful for other's to understand applications Mail Me. Q. What is Location of Jserv configuration files ?

Jserv configuration files are located in $IAS_ORACLE_HOME /Apache/Jserv/etc .

Q. What is plssql/database cache ? In order to improve performance mod_pls (Apache component) caches some database content to file. This database/plssql cache is usually of type session & plsql cache

session cache is used to store session information.

plsql cache is used to store plsql cache i.e. used by mod_pls

Q. Where is database/plssql cache stored ?

plssql & session cache are stored under $IAS_ORACLE_HOME/ Apache/modplsql/cache directory.

Q. How to determine Oracle Apps 11i Version ?

select RELEASE_NAME from fnd_product_groups;
You should see output like
RELEASE_NAME
-----------------------
11.5.9 or 11.5.10.2

Q. What is *.dbc file & whats is location of dbc file ?

dbc as name stands for is database connect descriptor file used to connect to database. This file by default located in $FND_TOP/secure directory also called as $FND_SECURE directory.

Click next to know more about this file and Best of luck for your interview. If you are not happy with quality of questions or want to submit Oracle 11i Apps Interview questions Mail Me.

Previous Page

Next Page

Oracle Apps 11i | Oracle Portal | Collaboration Suite | My Blog