PL/SQL Procedure consists of_______

PL/SQL - Quiz(MCQ)

Header and Footer

Header and Body

Body and Footer

None of the above

Correct Answer : Header and Body

Explanation : PL/SQL Procedure consists of Header and Body.

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