Tpes of indexes
7. When to use bitmap index / btree index?
8. Any performance issue faced because of index?
9. What are the new type of index in 11g?
10. What is NOCOPY ?where it is used?
11. What are the difference type of parameters in a procedure?
Types of parameters IN OUT INOUT
12. What is analytical function?
Analytical functions compute an aggregate value based on a group of rows. Analytical function return multiple rows for each group.