TCS PLSQL Interview Questions

PL/SQL Interview Questions, AskHareesh.blogspot.com

TCS PL/SQL Interview Questions

  1. What are the environments in your company?
  2. How to know which version is currently running in your database?
  3. Do you have any experience in data modeling?
  4. How to disable all triggers in a table?
  5. How many triggers are you created?
  6. How many triggers created on one table?
  7. Which will fire default first statement level or row level trigger?
  8. What is bulkcollect? And any restrictions in bulkcollect?
  9. What is the use of limit clause in bulkcollect?
  10. How to debugg your code?
  11. How to trace error handling?
  12. How to find which line error was raised?
  13. What are the methods there in save exceptions?
  14. What is functional based index? Write syntax?
  15. How to update complex view?
  16. Can you alter procedure with in package?
  17. Is it possible to open cursor which is in package in another procrdure?
  18. What is substr()&instr()?
  19. Difference between case and decode?
  20. Can you use sysdate in check constraints? If no, why?
  21. Difference between column level constraints & table level constraints?
  22. What is optimizer?



*/