What are the selectors in case of CASE statement?

PL/SQL - Quiz(MCQ)

Variable

Function

Expression

All of the above

Correct Answer : All of the above

Explanation : The selectors in case of CASE statement are Variable, Function or Expression.

Recently Updated in PL/SQL Questions

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

IN, OUT

IN, INOUT

OUT, INOUT

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?

OUT

INOUT

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?

Call

Drop

Create

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