Accenture PLSQL Interview Questions

PL/SQL Interview Questions, AskHareesh.Blogspot.com

Accenture PLSQL Interview Questions

  1. What are different types of queries
  2. Write a correlated sub query and explain how it works
  3. What are different type of statements
  4. What TCL do
  5. What is difference between stored procedure and function
  6. How you handle errors
  7. What is %type and %row type
  8. What are different types of cursors
  9. How implicit cursor works
  10. What are different type of triggers
  11. Write a pl/sql block for trigger at the time of insertion for inserting old and new values auditing table.
  12. What are different types of joins
  13. What self join do
  14. Write an example and explain about self join
  15. Write an example for left outer join and how output comes
  16. What is difference between in and = operator
  17. What is package
  18. Tell some advantages of packages
  19. What are collections in pl/sql
  20. What are pointers in c
  21. How you connect to data base
  22. some more interview questions asked in scope
  23. Difference between cursor for loop and for loop, which is faster?
  24. In proc and PL/SQL, which is faster?
  25. Which is best method to kill the process (unix or oracle)?
  26. Difference between c shell, bourn shell, k shell?
  27. What is inode?
  28. How to search two patterns using grep pattern?
  29. Difference between ls and find?
  30. Difference between view and snapshot?
  31. Difference between function and procedure?
  32. Why we cannot use DDL commands in procedure?
  33. Difference between global variable and static global variable?
  34. How to access variable of nested procedure?
  35. If we have both user exception and system exception, which will be handled first?
  36. Difference between anonymous block and normal block?
  37. Can we create snapshot for another schema?
  38. How to access table from another database?



*/