Interview Questions For Freshers(0-6 months) Oracle Apps DBA 11i/R12/12i

Here i am listing some very general interview questions for Oracle Apps DBA with 0-6 months experience :

Ques 1 Where are the front end user details stored?

The front end user details are stored in table fnd_user in database. You can query the database for the details you want to know as follows:

logon as database user apps then

sql> desc fnd_user;

sql> select <Column name> from <table>;

you will get the list of details that the table contain from which you can get the further details.

Ques 2 Is “apps” a database user or “application user”?

“apps” is a Database user.All the information about database users is defined in table dba_users so you can query the database to know about users.

sql> desc dba_users;

sql> select * from dba_users where username=’APPS’;

This query will give you all details of apps user.
Ques 3 Where are the database objects stored for the products ‘BEN’ &’FND’?

Database objects for the products like ‘BEN’ & ‘FND’ are stored in their own schema like BEN or APPLSYS (for FND), GL for GL objects

Ques 4 Can Middle Tier & DB run on different versions of OS?

Yes, Middle Tier & DB can run on different versions of OS. This type of configuration are known as Split Configuration.

Ques 5 Can different Middle Tier’s have different flavours of OS?
Yes different Middle tier’s can run on different flavours of OS.

Ques 6 How do we verify the no. of CPU’s running on a node?
Proc (/proc) file system provides easy information about CPU and their speed.To display the number of processors in linux you need to use /proc/cpuinfo file. This is a collection of CPU and system architecture dependent items, for each supported architecture a different list.Type the following command:

$ cat /proc/cpuinfo

Ques 7 How do i identify whether my environment is shared APPL_TOP or not?

To know whether the environment is shared APPL_TOP or not , login to first Middle Tier & create any file (like abc.txt) in the APPL_TOP. Now logout & login to other Middle Tier. If you can see that respective file in APPL_TOP, this means you are having shared APPL_TOP.

Question for readers:

Is it possible to start database from Middle Tier? If yes then how?

About the Author Atul Kumar

Leave a Comment:

18 comments

Chandrasekhar Das. says February 6, 2008

Hello Atul…..it’s looking good that one fresher can know little bit interview ques with answers…..it’s really great work…..thank u….
And please give more ques…..

vasanth says February 7, 2008

Hi Atul,

The Question no 6 “$ cat /proc/cpuinfo” I think it works only for Linux . Do you have similiar command for HP platforms specific (HP PA RISC and HP UX Itanium )

Famy Rasheed says February 7, 2008

Is it possible to start database from Middle Tier? If yes then how?

Yes..

Create a password file using orapwd

edit the initSID.ora for the parameter
REMOTE_LOGIN_PASSWORD=EXCLUSIVE

Now you can login as sys user from the middle tier as sysdba and startup the database from there..

Deepak says February 14, 2008

7 How do i identify whether my environment is shared APPL_TOP or not?
The better answer to this in my opionion would be looking at configuration file.

Atul Kumar says February 16, 2008

Thanks Deepak,
If possible please share with readers which file to check and what to check to confirm shared application tier

ramakrishna says February 19, 2008

Is their any Job Opening in Orcale Apps DBA for Freshers i.e(0-2)

sivanomula says March 1, 2008

Is it possible to start database from Middle Tier? If yes then how?

Ans. No, we can’t connect with sysdba privs from 806 or ias home
yes, it is possible if we grant sysdba privs to any user(ex:apps..)and enabling of orapwd file

Freekiezz says November 16, 2008

Hi Atul,

not sure but these may be the files we need to check :
httpd.conf, httpd_pls.conf, plsql.conf and listener.ora .

Even if the file system is shared , for a NAS where CSM Setup is done its better to have all the above files local to the host(by creating a link to the nonshared dir ) and modify them to contain local hostname entries instead of virtual name.

Any comments ?

Sam says January 24, 2010

Thank u and i am waiting for more

srikanth says November 7, 2010

HI ATUL,
i have a interview as a fresher so i need a fqas with ans..plz forward to following id;srikanth.ramagiri@live.com

shrinidhi says January 19, 2011

Hi ,
im looking for job openings in ORACLE DBA as a fresher please guide me regarding this.
have uploaded my resume to but not getting call regarding this . I have done oracle dba 10g course and awaiting for an interview .
my mail id is shrinidhi10@gmail.com
Thank you

Venkatesh says March 1, 2011

Hi …
i am looking for fresher oracle bda job….please tell me which is the best site to upload resume for ds job..i already uploaded in naukri and times jobs.com..but iam nt getting interview call letter,,,,,,so plz suggest me.my email-id:venkatesh.gtm@gmail.com

i am awaiting for your reply

kumar says July 8, 2011

HI ATUL,
i have a interview as a fresher so i need a fqas with ans..plz forward to following id;kumar6353@gmail.com

gautham says January 16, 2012

HI ATUL,
i have a interview as a fresher so i need a fqas with ans..plz forward to following id;gautham.menon47@gmail.com
i am awaiting for your reply

nazma says February 19, 2013

i hav an interview as a fresher ineed faq vt ans,(oracle core&apps dba) plz frward to mail id nazmadba7@gmail.com

venkat says May 8, 2013

Hello Mr. Atul, u have a very gud collection of apps dba interview qstns along with answers for freshers.

I have an apps DBA fresher interview so can u pls do me a favour of forwarding me any APPS DBA interview qstns which may help me in getting my dream job.

If u have any questions then plsss do forward me at venkat.anjaneya.dba@gmail.com

Thanks and am waiting for a positive response from u as soon as possible… 🙂

chintan soneji says July 14, 2014

i have a interview as a fresher so i need a fqas with ans..plz forward to following id;chintu.soneji94@gmail.com

mohit says July 24, 2014

hello sir,
i am basic larner of dba ,now i am going to facing interview, can u plz send some url to help in company work to easy to understand all technical thinks,plz send
Thank u

Add Your Reply