Matrix PLSQL Interview Questions

Matrix PL/SQL Interview Questions

1. 11g features
2. What are main advantages of 10g then other version(9i)
3. Syntax of collection
4. Write a query to display even/odd number from a table.
5. What is the exception; write syntax on user defined exception.
6. How many types of sub queries in oracle.
7. Syntax of correlated sub query.
8. Write syntax to execute procedure or function in sql.
9. What are sql functions?
10. Disadvantage of triggers.
11. Diff %type and %row type.
12. What cascade constrains.
13. What is in line view.
14. How to retrieve 3rd max sal
15. Write syntax indian time and time 12 hours and 24 hours.