Tuesday, 25 July 2017

Oracle Apps DBA Realtime Interview Questions

Hey DBA-mates,
When we prepared for the oracle dba interviews, we all need guidance for preparing interviews especially when we are fresher and going for any MNC companies such as ORACLE, CISCO, IBM, TCS, WIPRO etc...

That time we need to prepare the important questions and answers which we do in our college life hheheh and we start to search in Google for important dba interviews Questions and Answers. We read that and go for interviews.

But if you are fresher then you will not understand the stuffs correctly and you will not able to answers of the questions. And in MNC they will ask as per their working experiences.

Even I also used to do same things during my struggling time. Hey these words may hurt you but it is true. It is very hard to get chance without any experiences. We have to struggle and win it. We everyone do it. Only some lucky people get chance easily.

If you really want to test yourself, Please try these below questions which are very important for especially for MNC companies. Even these questions are for experienced DBAs also.

1). Let me know the flow of application when user login?
2). What is the purpose of authentication to connect todatabase?
3). Why u need GUEST/ORACLE to connect to database?
4). What is the purpose of JSERV?
5). How to increase the performance of Apache?

6). Tell me some issues with Apache?
7). Why you need httpd.pid? Why you need to clear that?
8). How do you increase the jvm size?
9). What is JVM?
10). If One of our dba can launch the forms and another unable to launch the forms? What will be the issue?

11). How to set trace at forms level?
12). If u have Concurrent request with pending–standby how do you troubleshoot?
13). If you have long pending requests and system become slow what you do?
14). How autoconfig works?
15). What Concurrent Tables that will cleanup when u run cmclean.sql?

16). What is PCP configuration? What is the use behind it? How to you configured?
17). What is diff between distributed AD and Shared APPL_TOP? What happens when u apply patch and distributed AD and Shared APPL_TOP?
18). What happens if you Miss Pre-Req patch and apply main patch and how to do continue?
19). How to do you skip a worker?

Hope this may useful and helpful. We have some more which we will post very soon as per real time experiences very important Questions and Answers. Please let us know for any concerns or suggestions through either comments box or Contact Us +ORA-DATA All the BEST DBA-mates.

Some more important links:


ora-data Team.


  1. Wonderful article! We are linking to this great post on our site.Keep up the good writing. Visit: Please Read More: Download Ebook: Ultimate Guide To Job Interview Questions Answers:

  2. nice information about oracle dba interview questions and answers
    Oracle Apps DBA Online Training

  3. I do accept as true with all the concepts you have
    introduced for your post. They're very convincing
    and will certainly work. Still, the posts are too quick for starters.
    May just you please prolong them a little from next time?
    Thanks for the post.


    1. Dear User,

      Thank you for your comments.

      ora-data Team


Thank you for your comments and suggestions. It's good to talk you.