MBT Company PLSQL Interview Questions

PL/SQL Interview Questions

MBT Company PLSQL Interview Questions

  1. How to fetch duplicate rows.?(with out using rowid);
  2. Write query to fetch details of candidates who are not females(including nulls);
  3. what is index, types of indexes?
  4. What is bitmap index & why is efficient?
  5. Diff between bitmap & binary index;
  6. how to know to which database we connected?
  7. what is trigger,types of triggers?
  8. where we use :old and :new ?
  9. Diff between fns and procds ?
  10. diff between pkg spec & pkg body?
  11. can we write nested blocks in pl/sql;
  12. what is propagation exception?
  13. can we create index for view?
  14. what do u know abt materialized view?
  15. what is the diff between dblink & materialized view?(incase of accessing)
  16. what is cursor, types of cursors?
  17. how do we process records in cursor?
  18. what is autonomous transaction?
  19. how do u identify autonomous trans in procedure?
  20. what is correlated subquery & give an exml?
  21. display  details of all employees  including who are not in deptno 40 (using outer         join).
  22. what is dbms_job ?
  23. What is dynamic sql?
  24. what is partition, why u go for partitions, and write the syntax?
  25. diff between triggers & integrity constraints?
  26. what are analytical functions(roll up,rank,cube)?
  27. what is sequence & where did u used in ur project?
  28. diff between view & materialized view?
  29. can we create index on materialized view?
  30. what is primary key & unique key?
  31. can we create index on primary key column?
  32. what is unique index?
  33. what is the syntax of organization table index?
  34. what is the main diff between normal index & organization table index?
  35. Can foreign key column accepts null values & duplicate values?
  36. Why we use autonomous trans & write syntax?
  37. What is the main diff between function and procedure?
  38. How we call a procedure?
  39. Is exec a sql statement?
  40. Tell me about function overloading?
  41. What is the diff between integrity constraints and triggers?
  42. Tell me about types of triggers?
  43. What is forward declaration?
  44. Can you select the salary by passing the eno as a argument in the procedure?
  45. Why you want to shift here?
  46. What about your present company?
*/