oracle apps dba interview questions and answers for experienced asked Top MNC company

Hi DBA-Mates,

Today we got these Questions which is asked in Interviews one of the top MNC.

We should not tell the company name here which may raise any concerns. Leave it, we should not worry about that all...

Here, we would like to request you all DBAs, please provide the Answers in Comment box and after reviewing we will provide below the Questions.

We can give here easily all the Answers but we want you guys to do some homework for better understanding and learning, really it work personally.

Question: Hi, How are you?

Answer: Hello, I'm doing well. How are you? [This may different, depends person to person]

Question: 1. Can you please briefly introduce about your experiences. 
Answer : [Best Answer in 10-20 lines, how to start is the main steps.]

Question: 2. How you scale yourself for APPS DBA and Core DBA.

Answer : [As per your skill and knowledge but always keep above 60% -- as per our expert and advice]

Question: 3. Suppose we are applying the patch and got failed due to some tablespace full, how you will take care?

Question: 4. what are the types of patching?
Answer: There are main 4 different types of patches

One-off patch

Mini pack Patch

Family pack patch

Maintenance pack patch

NLS Patch – For Languages patches like English, French, Japanese etc…

Note (Quick-Reference):

few one off patch = mini pack ,

few mini pack / family bundeled = family pack

all family pack fixed = Maintenance pack 

Question: 5. Have you applied HRMS patches?

Question: 6. why we enable maintenance mode?

Answer: Why we need to enable Maintenance Mode in oracle apps

Question: 7. what are the Patching options in R12.1.3?

Question: 8. why we use ADCTRL?

Answer: ADCTRL concepts and details with example

Question: 9. how frequently CPU patches we apply?

Answer: CPU patch concept and steps to apply in real time

Question: 10. What are the steps to apply the APPS Patches?

Answer : Steps to apply Apps patches in Real time scenario with example

Question: 11. Can we enable maintenance mode if our Application is running?
Answer: Yes

Question: 12. What are the High level Cloning Steps?
Answer : Step by Cloning EBS with clear Steps as per real time scenario

Question: 13. What does Adpreclone on APPS Tier?

Question: 14. How Autoconfig works and why we run?

Question: 15. If customers are complaining that a program is running for Long 

time, what you need to take actions?

Question: 16. Why and when we need to run GSS?

Question: 17. Suppose customers are complaining that only one module (example - GL) forms are opening slowly, what we need to check and troubleshoot for this?

Question: 18. Suppose CRM is down then what will happen and what to do?

Question: 19. If CRM is down then who will work for CRM? Which Concurrent Manager will act like CRM?

Question: 20. If status of a program is in Pending and Standby, what it means and what you will do?

Question: 21. Have you worked on PCP? Do you know setup for PCP?

Question: 22. Have you done SSO setup?

Question: 23. What are the parameters asked during applying apps patch? [Unnecessary questions asked by them lol hhhh]

Question: 24. If the concurrent program is running for long time, can we enable trace and how?

Some more important Links:

How to change apss password in R12.1.3

How to Duplicate a database using RMAN backup

How to apply CPU OCT 2015 patch on 10.1.3 in R12.1.3

Oracle RMAN Interview Questions and Answers

Oracle DBA Troubleshooting Tips and Guide

Regards,

ora-data Team