Interview Questions

Many friends and collegues preparing for an interview asks me lot of questions while preparing for interview so thought of adding quality questions to our site, I am writing them here with the best answer I could think of, may be you can come up with better reply.. Lets make an attempt for Apps DBA's looking for better option to shape their future for their Dreams.

What is the difference between different releases of Oracle Applications like 11i7,11i8,11i9,11i10.?
Every new release has their own new functionality and fix of bugs in earlier version. This is what I observed while working on different releases. If you find one do share to let this help our folks. Tech stack that comes with fresh installation is as follows

11i Release Versions
Product	11.5.7	11.5.8	11.5.9	11.5.10
Database Server	8.1.7.3	8.1.7.4	9.2.0.3	9.2.0.5
Forms Patchset	9	9	12	15
Reports	9	9	12	15
Client Tier
Jinitiator	1.1.8.16	1.1.8.16	1.1.8.16	1.3.1.18
Web Server	Apache 1.3.19	Apache 1.3.19	Apache 1.3.19	Apache 1.3.19
Jserv	1.1.2	1.1.2	1.1.2	1.1.2
JRE	1.1.8	1.1.8	1.1.8	1.4.2_04-b05
JDK	1.3.1_02	1.3.1_02	1.3.1_02	1.4.2
Self Service Framework	5.5.2.E	5.6E	5.7H	5.1O
Discoverer	4.1.41	4.1.41	4.1.46	4.1.48
Portal	3.0.9.8.1	3.0.9.8.1	3.0.9.8.4	3.0.9.8.4

11.5.7

• Autoconfig enabled. Prior to this release, manual changes to all the configuration files were required.

In 11.5.10

• we do not have APPS_MRC schema as such, now its functionalities are maintained in the product based schemas.
  

• It comes with AD.I, so maintenance mode feature comes with it. This feature is used for optimal performance and reduces downtime while applying patch as it shuts down Workflow business event system and sets function security thereby Apps functions are not available to users.

• OATM(Oracle Applications Tablespace Migration )

• AutoConfig Integration with AutoPatch- AutoPatch automatically calls AutoConfig to instantiate and run new templates contained in a patch. When AutoPatch is run in test mode, AutoConfig
  also runs in test mode