ORACLE APPS INTERVIEW QUESTIONS 

1. How to determine Oracle Apps 11i Version ?

Ans : select RELEASE_NAME from fnd_product_groups;

You should see output like

RELEASE_NAME———————–11.5.10.2

2. How to find Database version ?

Ans : SQL> select * from v$version;

The command returns the release information, such as the following:Oracle9i Enterprise Edition Release 9.2.0.7.0 – ProductionPL/SQL Release 9.2.0.7.0 – ProductionCORE 9.2.0.7.0 ProductionTNS for 32-bit Windows: Version 9.2.0.7.0 – ProductionNLSRTL Version 9.2.0.7.0 – Production

3. How to find opatch Version ?

Ans : opatch is utility to apply database patch , In order to find opatch version execute”$ORACLE_HOME/OPatch/opatch version”

You can check OPatch -lsinventory

4. How to find out invalid objects in the database

Ans : select count(*) from dba_objects where status =’INVALID’
(More …)