Which clause is used to close the cursor?

PL/SQL - Quiz(MCQ)

END

STOP

FINISH

Correct Answer : CLOSE

Explanation : CLOSE clause is used to close the cursor.

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