Questions faced at Portware

1. What are the new features of Oracle 10g according to Developer perspective
2. What are the different types of indexes? What happened if a table has an index
3. What will you do if the performance of a select query is low
4. What is a ref-cursor? Where will we use it
5. Define a collection. What are different types of Collections and its use
6. How do you know whether a table is having an index or not? And it is working or not?
7. What is the difference between Function and Procedure, Functionality wise
8. What is the use of a package? Why we go for a package instead of using a Procedure.