Oracle Interview Questions

When interviewing for Oracle Jobs it is important to be prepared to answer interview questions that challenge your technical knowledge.

Here are some Oracle interview questions that you can use to help you prepare. (You can find a link to the answers at the bottom the page)

1. What are the various types of queries?
2. What is a transaction?
3. What is implicit cursor and how is it used by Oracle?
4. Which of the following is not a schema object: Indexes, tables, public synonyms, triggers and packages?
5. What is PL/SQL?
6. Is there a PL/SQL Engine in SQL*Plus?
7. What are the various types of Exceptions?
8. What is the difference between a procedure and a function?
9. What is Over Loading and what are its restrictions?
10. What are the constructs of a procedure, function or a package?

Find the answers here.

Keeping your answers short but specific can help you portray your knowledge in a confident manner.

For more advice on perfecting your interview technique, we've partnered up with CV Knowhow who offer interview coaching so click here to find out more.

Good luck!