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.

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

Questions:

1. How to schedule Jobs in Oracle
2. What is difference between MAX and GREATEST functions
3. What do you mean by Aggregate functions
4.Name any Plsql Cursor Exceptions
5. What can be the output of SIGN function
6. How do you log the errors in Plsql
7. Hierarchical Queries