When DUP_VAL_ON_INDEX exception does is raised? - PL/SQL Quiz

PL/SQL - Quiz(MCQ)

When DUP_VAL_ON_INDEX exception does is raised?

A)

An invalid username or password is used to log on to the database by a program.

B)

When character strings are converted to numbers, it is raised if the string did not represent a valid number.

C)

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

D)

The error is raised if an attempt is made to close an unopened cursor or perform a cursor operation without permission.

Correct Answer : 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.

Recently Updated in PL/SQL Questions

Which of the following pass parameters can be referenced by procedure?

A)

IN, OUT

B)

IN, INOUT

C)

OUT, INOUT

D)

None of the Above

Correct Answer : IN, INOUT

Explanation : IN and INOUT pass parameters can be reference by procedure.

Which of the following cannot be overwritten by procedure?

A)

IN

B)

OUT

C)

INOUT

D)

None of the above

Correct Answer : IN

Explanation : IN pass parameter cannot be overwritten by procedure.

Which of the following can be performed in PL/SQL Procedure?

A)

Call

B)

Drop

C)

Create

D)

All of the above

Correct Answer : All of the above

Explanation :

In PL/SQL Procedure, the following functions can be performed :

Call

Drop
Create

New Technologies MCQ's

Machine Learning

Artificial Intelligence

Ethical Hacking

Microsoft Azure

Cloud Computing

Quantum Computing

Neural Networks

Virtual Reality

Augmented Reality

Advertisement