Explaining triggers predicates and trigger mutating tables

Question

Question 1) What do you mean by the Oracle data types?

Question 2) Write down the difference between REF and DEREF operators.

Question 3) Explain sequences data bases in detail.

Question 4) Describe abstract data types.

Question 5) What are the different data types in PL/SQL?

Question 6) Write down the advantages of SQL CODE?

Question 7) Distinguish implicit and explicit cursors.

Question 8) What do you mean by packages?

Question 9) Write brief notes on BFILE.

Question 10) Explain LOBs (Large Objects).

Question 11) Overview of operators and describe built-in functions.

Question 12) Briefly explain object oriented programming concepts with suitable example.

Question 13) Write detailed notes on:

(a) Exception handling.

(b) Advantages SQLERRM.

Question 14) Write in detail Triggers predicates and Trigger Mutating tables.

Question 15) Describe dynamic PL / SQL and overview of LOBs.