Oracle DBA interview questions

  1. What is your experience in the field of Oracle DBA and how will it help you getting this job?
  2. Giving an example can you explain how a co-related subquery differs from a nested sub-query?
  3. 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?
  4. How do you go about shutting down a database and starting it up?
  5. If you were to mount a database on a parallel server, how would you go about doing it?
  6. What database operating conditions would you prefer between ARCHIVELOG and NOARCHIVELOG mode and why?
  7. If some applications are running slow, how would you debug the database to optimize them?
  8. If the database errors out, what will be your approach to troubleshoot the error with no assistance from anyone else?
  9. What makes you confident about handling the DB we have setup here looking at the diversity?
  10. Now that you are familiar with our working and your job role, what is the salary you expect?

Category: Software Interview Questions

Leave a Reply