IBM PLSQL Interview Questions

PL/SQL Interview Questions

IBM PLSQL Interview Questions

  1. Tell me about your project and client
  2. What is difference between procedure and function? 
  3. Difference truncate and delete             
  4. Can we use where condition with truncate
  5. Can you explain the truncate and delete with trigger
  6. Can we use truncate and delete command to disable the referential integrity constraint
  7. How did you export the data from database to excel file
  8. How many types of functions in UTL_FILE package
  9. What function you are using to load the data in UTL_FILE package
  10. How many types of trigger
  11. How many max triggers you will declare
  12. What is instead of trigger?
  13. We have two duplicate rows, how will you delete only one row
  14. How will you display rownum?
  15. What is implicit and explicit cursor?
  16. What is exception?
  17. How many types of exception
  18. Can we have more than one exception?
  19. What are predefined exceptions?
  20. Do you know TOO_MANY ROWS, when that exception will occur and NO_DATA FOUND
  21. How to catch any type of exception
  22. Can we commit in trigger
  23. What is autonomous transaction?
  24. What is view
  25. Can we delete a record in view
  26. Can we delete a record  more than one table
  27. Can we write trigger on view
  28. Do you have use any debugging tool
  29. Do you know global variable, difference between global variable and parameter variable?
  30. Do you know about cascading triggers

Different companies PL/SQL Interview Questions



*/