When COLLECTION_IS_NULL exception is raised?

PL/SQL - Quiz(MCQ)

This error message appears when a number is divided by zero.

If a select into statement fails to return any rows, it raises this error.

A unique index column with duplicate values is raised when this error occurs.

The exception is thrown when an uninitialized nested table or varray is attempted to be populated with collection methods other than exist, or when an element of an uninitialized nested table or varray is attempted to be assigned values.

Correct Answer : The exception is thrown when an uninitialized nested table or varray is attempted to be populated with collection methods other than exist, or when an element of an uninitialized nested table or varray is attempted to be assigned values.

Explanation : COLLECTION_IS_NULL exception is raised when an uninitialized nested table or varray is attempted to be populated with collection methods other than exist, or when an element of an uninitialized nested table or varray is attempted to be assigned values.