EXPERT RESPONSE
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.
|