How many types of PL/SQL Loops are there?

PL/SQL - Quiz(MCQ)

Correct Answer : 4

Explanation : PL/SQL provides four kinds of loop statements :

* basic loop
* WHILE loop
* FOR loop
* cursor FOR loop.

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