Home » PL/SQL MCQs

When ACCESS_INTO_NULL exception does is raised?

119. When ACCESS_INTO_NULL exception does is raised?

1. A unique index column with duplicate values is raised when this error occurs.
2. An invalid username or password is used by a program to connect to a database.
3. An automatic assignment of a value to a NULL object raises this exception.
4. It is raised when more than one row is returned by a SELECT INTO statement.

Answer: C) An automatic assignment of a value to a NULL object raises this exception.

Explanation:

ACCESS_INTO_NULL exception is raised when an automatic assignment of a value to a NULL object raises this exception.