Wednesday 22 August 2018

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: 7. what are the Patching options in R12.1.3?

Question: 8. why we use ADCTRL?

Answer: ADCTRL concepts and details 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:
Regards,
ora-data Team