1) What do you understand by exceptions. Write down the difference between user defined and predefined exceptions.
2) What do you understand by PL/SQL? Write down the advantages of PL/SQL over SQL. Describe the functions of control loops with suitable examples.
3) What do you mean by query language? Explain various forms through which data can be retrieved in query language.
4) Describe nested tables and varying arrays. How do we maintain row count?
5) What do you mean by built in packages? Explain with suitable examples.
6) Describe advantages and functions of sub programs and packages with suitable examples.
7) Explain different data types and operators in ORACLE. What is the function of cursors?
8) What are the differences and similarities between triggers and procedures? Explain with suitable examples.
9) What do you mean by trigger? What are the various types of triggers?
10) What is a software package? Write down advantages of packages and one specification of packages.