Multiple choice technology programming languages

Which of the following exception is raised when an insert or update attempts to create two rows with duplicate values in columns constrained by unique index

  1. NOT_LOGGED_ON

  2. NO_DATA_FOUND

  3. VALUE_ERROR

  4. DUP_VAL_ON_INDEX

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DUP_VAL_ON_INDEX is the Oracle exception raised when trying to insert or update a row that would violate a UNIQUE constraint. NO_DATA_FOUND is when SELECT returns no rows, VALUE_ERROR is for type conversion issues, and NOT_LOGGED_ON relates to database connection.