Home » PL/SQL MCQs

When COLLECTION_IS_NULL exception is raised?

121. When COLLECTION_IS_NULL exception is raised?

1. A unique index column with duplicate values is raised when this error occurs.
2. 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.
3. If a select into statement fails to return any rows, it raises this error.
4. This error message appears when a number is divided by zero.

Answer: B) 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.