Question For Collections

PL/SQL Interview Question  for Collections.

What is Collection? How many type of collection?
Why or when we will use collection?
What is the difference between PL/SQL table, Nested table and Varrays ?
What are common exception related with collection?
What are common methods of handling exceptions?
Give sample defination of varray of object and table of object?
What is the difference between Collection and Record?
What is inline storage and out of line stogare of the nested table?
Write a program using collections.

DBMS_XPLAN

One more way we can see the Explain Plan by using DBMS_XPLAN package. DBMS_XPLAN automatically queries the last plan in PLAN_TABLE. It u...