Lot of Oracle Apps 11i beginners ask me about Interview questions
specially those who are with 2 years or less work exp. as Apps DBA.
These apps 11i Technical Interview Questions are Just for reference
purpose & understanding Oracle applications 11i. Oracle Apps Interview
questions which Interviewer can ask you depends on lot of things
like your work experience,your CV, client's requirement, role for which you are
applying. I don't take any guarantee for any answers , all answers mentioned
here are based on my expertise & feedback I receive from you. If you think any answer
is not right or want to discuss about any 11i apps question mentioned here
As there is no short cuts for success and same applies to
your role as oracle Apps 11i DBA so don't just rely on these questions
but try to understand oracle application E-Business Suite Via these questions.
To check more interview Q's click Next on bottom of this page.
I'll keep updating Interview questions from time to time.
Now without discussing too much lets start with very common question
which almost all Interviewer's ask from DBA with 2-4 years of Exp.
(If you don't know answer don't worry believe me 90% apps dba beginners
don't know answer.
Q. What is wdbsvr.app file used for? What's full path of this file? What's
significance of this file ?
I'll again suggest you don't just remember answer & try to solve mystery
behind this file. First where this file exists ? You can find this file
Based on file location I am sure you can say this is related to Apache,
& looking into modplsql/cfg , I am sure you will say its related to mod_pls
(mod plsql component of Apache/Oracle 11i WebServer) configuration file. This file is used by mod_plsql component
of Apache to connect to database. So when you type url
http://hostname:port/pls/SID , whenever Apache(11i Web Server) finds that request is for
/pls/ then Apache delegates this request to mod_pls component which in turn
pick this file & check if there is any DAD with name SID (in our example its
Sample entry in wdbsvr.app
connect_string = VISION11I
password = apps
username = APPS
default_page = fnd_web.ping
On typing http://hostname:port/pls/VISION11I , it will connect to database
using apps schema & will return you page fnd_web.ping ( where fnd_web is package & ping is procedure
or vise versa).
So story about this file doesn't stop here , this url which I mentioned
about is quite useful in troubleshooting so you can check if database connection is working
fine or not. Another thing you want to check about this file is since it stores
APPS password you need to change here whenever you change apps password .