Sunday 24 November 2019

Realtime Oracle Apps DBA Interview Questions and Answers

Dear DBA-Mates, Latest Apps DBA Interview Questions and Answers.
Hope you all are doing Good!!! We have some topics but due to busy scheduled not able to present here.

But back with some New Questions and Answers which may useful here, also I found as these are simple and good questions.

Questions:
Q 1. Please describe about your job and task activity?

Note: As we all know this is very common question and answer… It depends on person to person…

Q 2. How to do troubleshoot oacore?

Q 3. Where is location path of oacore log file?

Q 4. How to find out which user is pointing to which oacore in case we have 5 oacore?

Note: Please answer this questions if anyone aware about it.

Q 5. What is http server and how it works?

Q 6. What is http.conf file and ohs.conf file and where is the location?

Q 7. What is EBS Login flow?

Q 8. How to troubleshoot Long running program if there is no lock, no server load and everything is normal?

Q 9. What is EBS version?

Q 10. What will happened if you run Prepare phase?

Q 11. What is location of Patch log?

Q 12. If we have created custom top, how adop will sync to patch file system?

Q 13. How the prepare phase knows to sync Custom_top to patch file system?

Q 14. If we have applied small patches then do we need to run fs_clone phase?

Q 15. If cutover failed due to some reason, how to troubleshooting?

Q 16. If u ran prepare phase, 20 programs are running, and during cutover phase once completed what will be the status of those programs?

Q 17. How to create Weblogic user?

Q 18. Have you worked on any other technique other than EBS/DB?

Q 19. Have you done patching in Endeca?

Q 20. How ebs patch sync with Endeca?

Q 21. What is the version of RAC?

Q 22. What is flaks in 12c RAC , new feature in RAC?

Q 23. How you worked on RMAN?

Q 24. What is backup strategy?

Q 25. How to find out database wait events?

Note: Answer will be publish very soon.

Some more useful and helpful links:
Regards,

4 comments:

  1. Thanks for the questions, please send one more mailer once the answers are published.

    ReplyDelete
  2. Thanks for sharing such a helpful post. Keep posting. Oracle DBA Course

    ReplyDelete
  3. Answers are still not published?

    ReplyDelete

  4. Dear Krishna,

    Sorry, we missed it due to some personal issue but will work on it once free... Many of answers are already in blog.
    Thanks,
    ora-data Team

    ReplyDelete

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