Q

Oracle DBA interview questions

A SearchOracle.com user asks what questions they can expect in an interview for the position of a DBA.

I have two years of experience in J2EE and PL/SQL technologies. I recently completed my Oracle 10g (OCA) and (OCP) database administration certifications. I have an interview next week for the role of DBA. What are the possible questions I can expect?
Unless this is an entry-level DBA position, you can probably expect a lot of questions about your lack of experience as a DBA. Having the certifications will certainly help you combat this with the fact that you are well-educated and well-versed in database administration. However, you may encounter a lot of real-world type questions designed to trip you up. For example, "Explain how you would go about escalating an iTAR with Oracle" or "Describe a time when you had to recover a database." You might be able to combat the latter with your knowledge and describe a scenario when you would need to recover and how you would go about it.

On the non-technical skills end, you may encounter questions like:

  • Describe your strengths.
  • Describe your weaknesses (often the hardest to talk about).
  • Talk about a time when you went above and beyond to succeed.
  • Talk about a time when you failed. What did you learn?
  • Why did you / are you leaving your current job?

For more advice, you can read my series on becoming an Oracle DBA here at SearchOracle.

I hope this helps and good luck!

This was last published in May 2008

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close