Asked the below questions in the written test. 1. Define Packages and advantages of using packages 2. What information you require for designing a table? 3. What is bulk collect in PLSQL? Illustrate with an example. 4. How can one protect PLSQL source code? 5. Assume that a structure of an employee table is as given below and the employee table data as given below. EMP NO | ENAME | MGR |SAL |HIRE DATE | DEPT NO| 7369 | Smith | 7902 | 800 | 17-Dec-80 | 10 7521 | Wart | 7698 | 1250| 22-Feb-81| 30 6. Write a Query to get the running total of salary on department wise. 7. Write a hierarchical query to get the employee reporting to manager. 8. what are ref cursors? give an example. What are week and strong cursors. 9. Write about application tuning or SQL tuning for performance upgrade. 10. What are the ways of executing a dynamic SQL 11. How a commit or rollback done in table level trigger. 12. What is the difference between a foreign key and a reference key. 13. Name few 11g PLSQL features introduced in oracle 11G. 14. What are exceptions. Name oracle predefined exceptions that you have used in application development. 15. What oracle supplied that you have used/known. 16. What are Varrays/Nested tables. Below questions in the F-F. 1. Tell me about yourself. 2. What is Clustered index? 3. What are all the different types of indexes? 4. oracle 11g new PLSQL features. 5. How to do application/SQL performance tuning.
