Top 17 Open Ended Oracle DBA Interview Questions

A good DBA will be able to teach, and train, others. So how do you find such a person? The answer is easy: you talk with them.

Than, why not ask the most basic questions you can, right from the start? The answer may surprise you, but the conversation is likely to reveal the depth of their experience right from the start.

Here are some basic open ended questions we have listed down which will help you as an interviewee as well interviewer.

1. What is the most challenging aspect of your job?
2. Do you treat your test and production systems differently? If so, why?
3. How do you troubleshoot problems in your current role?
4. What DBA activities you do everyday?
5. What is your typical day like?
6. What other parts of your organization do you interact with and how?
7. Do you consider yourself a development DBA or a production DBA and why?
8. What database and overall architecture would you suggest for testing new middleware without impacting production?
9. Explain one backup and recovery scenario which you have performed
10. What you will do if someone complain that database is running slow?
11. How do you assess my database’s health?
12. How would you approach a performance problem with a three-tier application?
13. How do you test your backup/recovery procedures?
14. How would you support the upgrade process for multiple applications,with different application rollout cycles, in the same instance?
15. What should consist of DW Team?
16. Why we should hire you?
17. Can you explain which is the most difficult scenario which you have faced in your career?

You can also refer Exadata Interview Questions and Answers eBook to get maximum success in interview.