30 TOP Oracle Pl/SQL Interview Questions and Answers

List of top 30 most frequently asked oracle pl/sql interview questions and answers pdf download free

Oracle Pl/SQL Interview Questions and Answers List

  1. What is difference b/w stored procedures and application procedures, stored function and application function?
  2. Explian rowid, rownum?what are the psoducolumns we have?
  3. what is the starting oracle error number?
  4. In a Distributed Database System Can we execute two queries simultaneously? Justify?
  5. How we can create a table in PL/SQL block. insert records into it? is it possible by some procedure or function? please give example?
  6. How to avoid using cursors? What to use instead of cursor and in what cases to do so?
  7. State the difference between implict and explict cursors?
  8. How to know the last executed procedure?
  9. How can a function retun more than one value in oracle with proper example?
  10. If the application is running very slow? At what points you need to go about the database in order to improve the performance?
  11. What is the basic structure of PL/SQL?
  12. What are the components of a PL/SQL block?
  13. What are the datatypes a available in PL/SQL?
  14. What are % TYPE and % ROWTYPE? What are the advantages of using these over datatypes?
  15. What is difference between % ROWTYPE and TYPE RECORD?
  16. What will the Output for this Coding.
  17. What are the Restrictions on Cursor Variables?
  18. Can we declare a column having number data type and its scale is larger than pricesion.
  19. What will happen after commit statement?
  20. Explain the usage of WHERE CURRENT OF clause in cursors?
  21. What is a database trigger? Name some usages of database trigger?
  22. How many types of database triggers can be specified on a table? What are they?
  23. Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? Why?
  24. What are two virtual tables available during database trigger execution?
  25. What happens if a procedure that updates a column of table X is called in a database trigger of the same table?
  26. Write the order of precedence for validation of a column in a table?
  27. What is an Exception? What are types of Exception?
  28. What is Pragma EXECPTION_INIT? Explain the usage?
  29. What is Raise_application_error?
  30. What are the return values of functions SQLCODE and SQLERRM?

This entry was posted in Interview Questions. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *