Tech Mahindra PLSQL Interview Questions

PL/SQL Interview Questions

Tech Mahindra PLSQL Interview Questions

  1. Introduce yourself
  2. Difference between having and group by
  3. Difference between case and decode
  4. Difference between delete and truncate
  5. How many types of indexes
  6. What is trigger and types
  7. Diff b/w view and materialized view
  8. Can we update the view
  9. I have one table i created view and materialized view on a table if i delete a table, Can i see the view and materialized view?
  10. Can u call function in same function
  11. Can we use tcl commands in trigger
  12. What is the cursor and ref cursor
  13. Tell me your project
  14. Difference b/w loop and bulk collect which is the faster way
  15. What is global table
  16. Can we load the data from table to table through utl_file package
  17. Difference b/w sql *loader and utl_file package
  18. Which is the faster way to load the data
  19. Description about project?
  20. What r the packages, functions, procedures you Developed in your project what are their Functionality?
  21. In which format u got the project?
  22. How u started with u r project?
  23. What r the steps u followed to create tables in Your project?
  24. How you involved in db design process?
  25. What r the scripts u wrote for inserting and Deleting data from db?
  26. How u export the data from db to excel file
  27. Where u stored the files in db?
  28. How u execute the code in sql prompt?
  29. Tell me some names of functions and Procedures that u created in u r project?
  30. What is the name of requirement Specification?
  31. What are the path names u provided to
  32. Execute u r coded data?
  33. Steps to get the data from oracle to unix Environment?




*/