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.]
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
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
Answer: Why we need to enable Maintenance Mode in oracle apps
Question: 7.
what are the Patching options in R12.1.3?
Question: 9.
how frequently CPU patches we apply?
Answer: CPU patch concept and steps to apply in real time
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
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
Answer: Yes
Question: 12.
What are the High level Cloning Steps?
Answer : Step by Cloning EBS with clear Steps as per real time scenario
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
Very nice article
ReplyDeleteOracle SOA Online Course Bangalore
ReplyDeleteThank you for awesome blog. I followed each and every step. and it is successful.
Such a very useful article. Very interesting to read this.I would like to thank you for the efforts you had made for writing this awesome article.
Dear Jopina,
DeleteThank you for your valuable feedback.
Regards,
ora-data Team
A motivating discussion is worth comment. There's no doubt that that you ought to publish more on this issue, it
ReplyDeletemight not be a taboo subject but typically people don't speak about these subjects.
To the next! Many thanks!!
Loving the info on this internet site, you have done outstanding job on the content. I followed each and every step. and it is successful.
ReplyDeleteSuch a very useful article. Very interesting to read this.I would like to thank you for the efforts you had made for writing this awesome article.
Hi Emily,
DeleteThank you very much , really feel good after your such comments.
Hope helpful to you all the info.
Regards,
ora-data Team
I’ve been following you since you’ve started your blog.This is top notch information and I'm really happy to connect with your great work.
ReplyDeleteSuperb information from this article and I have to tell you, your blog giving the best and useful information.
Thank you for awesome blog.it helped me a lot :)
Dear Sophia,
DeleteThank you very much for your valuable feedback and words.
It is really feel very nice to hear by you, it is big complement for us.
We will always try to provide better contents which useful to us or everyone here.
Thanks, thanks a lots :)...
Regards,
ora-data Team
Hiya, I’m really glad I have found this information. 😅
ReplyDeleteToday bloggers publish only about gossips and net and this is really annoying. A good web site with interesting content, this is what I need. Thanks for keeping this web site, I’ll be visiting it.
Dear Lovely,
DeleteThank you very much for your valuable and kind feedback.
It is our pleasure and thanks to visit here...
Regards,
ora-data Team
Loved reading your article. All the facts have been explained clearly. Thanks for sharing. 🤟
ReplyDeleteNice post. It will helpful for those who are thinking to go for interview.
ReplyDeletehttps://www.vertexplus.com/sg/en/mobile-application-development
Thank you, this is very useful for us.
ReplyDeletevisit : Digital Marketing Training in Chennai
Digital Marketing Course in Chennai
Its really helpful for the users of this site. I am also searching about these type of sites now a days.
ReplyDeleteOracle Apps DBA Training in Bangalore