- What is your experience in the field of Oracle DBA and how will it help you getting this job?
- Giving an example can you explain how a co-related subquery differs from a nested sub-query?
- If I would want to automate a SQL query deployment and email the results to users, what is the cron I would need to write?
- How do you go about shutting down a database and starting it up?
- If you were to mount a database on a parallel server, how would you go about doing it?
- What database operating conditions would you prefer between ARCHIVELOG and NOARCHIVELOG mode and why?
- If some applications are running slow, how would you debug the database to optimize them?
- If the database errors out, what will be your approach to troubleshoot the error with no assistance from anyone else?
- What makes you confident about handling the DB we have setup here looking at the diversity?
- Now that you are familiar with our working and your job role, what is the salary you expect?
Oracle DBA interview questions
Previous post: Relational database interview questions
Next post: Oracle PLSQL Interview Questions