Questions at Infinite

1. Where do we use HAVING
2. What is the use of GROUP BY clause
3. Have you ever used UTL_FILE
4. Have you worked with TEXT IO
5. What  is the use of NO COPY
6. What is PRAGMA Directive
7. What is an Autonomous Transaction
8. Have you ever heard about HINT
9. What do you mean by Analytical functions
10. Difference between RANK and DENSERANK
11. Can u fire a DML statement on a view
12. What is the use of Materialized view
13. Can u use a DDL in a procedure
14. What is the difference between TRUNCATE  & DELETE. And explain difference between their back ground processes
15. Have you ever used Triggers
16. What is Collections
17. Explain about Pipelined functions
18. What is a Cursor
19. What is difference between Explicit Cursor and Ref-Cursor
20. Difference between DECODE and CASE