What is the difference between Local & Global Variables? - PL/SQL Quiz

PL/SQL - Quiz(MCQ)

What is the difference between Local & Global Variables?

A)

Variables in an outer block are defined as local variables since they cannot be accessed from the outside whereas the innermost block declares global variables.

B)

Variables in an inner block are defined as local variables since they cannot be accessed from the outside whereas the outermost block declares global variables.

C)

Variables in an outer block are defined as global variables since they can be accessed from the outside and the innermost block also declares global variables.

D)

Variables in an inner block are defined as global variables since they cannot be accessed from the outside whereas the outermost block declares local variables.

Correct Answer : Variables in an inner block are defined as local variables since they cannot be accessed from the outside whereas the outermost block declares global variables.

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