Here are few more interview Questions targeted for Apps DBA’s with work exp. ranging from 1 to 3 years.
For answers to these question and many more Interview questions for Apps DBA’s visit http://teachmeoracle.com/forum
If you wish to share interview questions drop me a mail or leave them as comment on this post
Q. How you will troubleshoot if concurrent request is taking long time ?
Q. If you are applying a patch.It was started successfully. In the middle you realise nothing happening and no update in patch log file,worker log file (No updates & no error message). What to do & How to troubleshoot ?
Q. Why there are three ORACLE_HOMEs in 11i or R12 ?
Q.What is difference between shared appltop and staged appltop ?
Q. what are the request incompatibilities ? how conflict resolution manager solve them?
Q.Where and how you update workflow notification mailer configuration setting ? (This depends on which workflow mailer you are running C Mailer or Java Mailer )
Q. If you want to change Concurrent Manager log and out file location , Is it possible ? If Yes, How ? If No, why not ?
Q. What are conflict resolution managers in CM ?
Q. What are interoperability patches ?
Q. How frequent you run Gather Schema Statistics program & with what option ? Why you need to run it ? What is cost based optimizer ?
Q. Name few common issues you encountered recently related to Web Server, Forms Server, Concurrent Manager (CM), Jinitiator, Database, Cloning, Patching .
Q. What all things you will check after cloning and before handing over instance to end users ?
Q. If users complain that reports are not running, what you will do to troubleshoot ?
Q. What is Rep-300 toolkit error ? Did you ever encounter this ?
Q. Share configuration/setup you have done w.r.t. Apps (expect some questions on that setup) ?
Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.