There are lots and lots of questions that can be asked during the interview process. Each company is different. Go to Google and search for "Oracle interview questions" and you will find plenty of examples.
One of the things I do is to ask the candidate to provide step-by-step examples of how to do something. For instance, I sat in an interview once where other DBAs asked the candidate what type of backups they had done on their systems. The candidate replied "hot backups." The other DBAs were satisfied with this answer. But I sensed that the candidate was not completely honest with their experience level. So I asked the candidate to describe the exact steps his backup script performed. He didn't need to be completely accurate. But I quickly found out that this candidate had no clue what major steps needed to be taken to perform a hot backup in an Oracle database. So be prepared to provide examples of how you do things in addition to what things you have done.
Dig Deeper on Oracle DBA jobs, training and certification
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.