Capgemini PLSQL Interview Questions

PL/SQL Interview Questions

Capgemini PLSQL Interview Questions

  1. What are Your Roles And Responsibility?
  2. How To Communicate To Your Pm?
  3. Select Count(1) From Dual;,What Is Output?
  4. How to delete duplicate records from table without Distinct Clause
  5. How To Retrieve Second Height Salary From Table?
  6. Diff B/W Primary Key & Unique Key?
  7. Diff B/W Procedure & Package?
  8. Which Is Better Procedure Or Package?
  9. What Is Cursor?Types Of Cursor? And Diff B/W Cursors?
  10. What Is Exception? Types Of Exceptions?
  11. Tell Me Some User_Defined Exceptions With Error Codes?
  12. What Is Sqlcode And Sqlerr?
  13. What Is Ref_Cursor? Type Of Ref_Cursors And Diff B/W?
  14. How Give Privilege A One Procedure In Package?
  15. What Is %Type & %Rowtype? What Is Main Use?
  16. How To Improvee Performence?
  17. What Is Bulk Collect? What Is Use Of Limit Clause In Bulk    Collect?
  18. What Is Forall?
  19. What Is Merge Statement? Give Me Syntax?
  20. What Is View? Use Of View's?
  21. What Is Nocopy Clause?Where It Is Used?
  22. What Are The Environments Are There In Your Company?
  23. How To Connect Your Database?
  24. What Are The Shartcut Of Compile & Execution Of    Programes In Sql Developer Tool?
  25. Are you faced Any Trouble In Your Project?
  26. What Are The Module's , You Are Working?
  27. Which Will Fire Default First Statement Level Or Row Level   Trigger?
  28. What is bulkcollect? And any restrictions in bulkcollect?
  29. What is the use of limit clause in bulkcollect?
  30. How to debugg your code?
  31. How to trace error handling?
  32. How to find which line error was raised?
  33. What are the methods there in save exceptions?
  34. What is functional based index? Write syntax?
  35. How to update complex view?
  36. Can you alter procedure with in package?
  37. Is it possible to open cursor which is in package in    another procrdure?
  38. What is substr()&instr()?
  39. Difference between case and decode?
  40. Can you use sysdate in check constraints? If no, why?
  41. Difference between column level constraints & table level    constraints?
  42. What is optimizer?
  43. What is nested_loop join?
  44. What is pivot operater?
  45. Tell me some oracle 10g features?
  46. What is m_view?
  47. What is master & detail tables?
  48. What is sqlcode and sqlerrm?
  49. Diff b/w procedure & packages?
  50. What are the dis_adv of packages?


*/