1. What is a transaction ? 2. What is implicit cursor and how is it used by Oracle ? 3. What are the various types of Exceptions ? 4. Can you pass parameters in packages ? How ? 5. What are the various types of database triggers ? 6. What are mutating triggers ? 7. Describe Oracle database's physical and logical structure ? 8. What is a forward declaration ? What is its use ? 9. What are actual and formal parameters ? 10. What are the types of Notation ? 11. What are various types of joins ? 12. if you insert a row in a table, then create another table and then say Rollback.In this case will the row be inserted ? 13. is there a limit on the size of a PL/SQL block? 14. Can one read/write files from PL/SQL? 15. Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ? 16. What is the difference between a procedure and a function ? 17. Can you have two functions with the same name in a PL/SQL block ? 18. What are the various types of parameter modes in a procedure ? 19. What is Over Loading and what are its restrictions ? 20. Why Create or Replace and not Drop and recreate procedures ? 21. When to create indexes ? 22. How can you avoid indexes ? 23. What is the difference between the conventional and direct path loader? 24. What is SQL*Loader and what is it used for? 25. What is difference between View and Materialized View 26. How to find Table Fragmentation in Oracle Database 27. How can I find all locked objects in Oracle? I need a script to identify all locked objects. 28. What is Query Result Cache in Oracle Database 11g 29. What is the difference between a btree and a bitmap index? I need to understand the structural differences between a btree and a bitmap index and understand then to use a b-tree versus a bitmap index on a table column. 30. What is an "explicit" table lock? I understand that Oracle manages all locks, also I don't understand when I would want to explicitly lock a table? What is the process of explicitly locking a table?