Home » PL/SQL MCQs

When DUP_VAL_ON_INDEX exception does is raised?

122. When DUP_VAL_ON_INDEX exception does is raised?

1. A unique index column with duplicate values is raised when this error occurs.
2. The error is raised if an attempt is made to close an unopened cursor or perform a cursor operation without permission.
3. When character strings are converted to numbers, it is raised if the string did not represent a valid number.
4. An invalid username or password is used to log on to the database by a program.

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

Explanation:

DUP_VAL_ON_INDEX exception is raised when an attempt is made to close an unopened cursor or perform a cursor operation without permission.