Oracle PLSQL Interview Questions

  1. Can you briefly share your experience in the field of PLSQL as to how long have you been using it and the different challenges you have faced?
  2. What according to you separates a function from a procedure and from an anonymous PLSQL block?
  3. Why do you need to use a DECLARE statement?
  4. What is the significance of the SQLERRM and when is this function used?
  5. What are triggers and name the different triggers used by a PLSQL developer?
  6. Explain the different forms of cursors that you are aware of and what are the differences between them?
  7. If I use a CREATE TABLE statement after an INSERT statement and then follow it up by a ROLLBACK statement, will I be able to insert rows?
  8. Why does one use a & operator in PLSQL and how is it different from using a && operator?
  9. How is a unique key separate from a primary key while using a PLSQL environment?

10.  If you have any other questions pertaining to the job role, please let us know?

Category: Software Interview Questions

Leave a Reply