PL/SQL - Variables MCQ Questions And Answers

Variables MCQs : This section focuses on "Variables" in Pl/Sql. These Multiple Choice Questions (MCQ) should be practiced to improve the Pl/Sql skills required for various interviews (campus interview, walk-in interview, company interview), placements, entrance exams and other competitive examinations.

1. A _______ is nothing but a name given to a storage area that our programs can manipulate

A. object
B. constant
C. variable
D. literals

View Answer

2. variable names are ?

A. case-sensitive
B. not case-sensitive
C. Both A and B
D. None of the above

View Answer

3. When you provide a size, scale or precision limit with the data type, it is called a?

A. identifier declaration
B. non declaration
C. constrained declaration
D. unconstrained declaration

View Answer

4. Constrained declarations require less memory than unconstrained declarations.

A. Yes
B. No
C. Can be yes or no
D. Can not say

View Answer

5. How many types of variable scope?

A. 1
B. 2
C. 3
D. 4

View Answer

6. Variables declared in an inner block and not accessible to outer blocks known as?

A. Local variables
B. Global variables
C. Nested variable
D. None of the above

View Answer

7. A Variable in PL/SQL should not exceed ________ characters ?

A. 10
B. 20
C. 30
D. 40

View Answer

8. Which of the following is/are TRUE about PL/SQL Variables?

A. Variables serve as a means for programmers to temporarily store data during code execution.
B. PL/SQL programs benefit from its use.
C. There is nothing special about it other than being the name of a storage area.
D. All of the above

View Answer

9. 9. PL/SQL Variable needs to be declared in the ?

A. Variable Section
B. Declaration Section
C. Initialization Section
D. Exception Section

View Answer

10. PL/SQL assigns it a default value of NULL.

C. Can be true or false
D. Can not say

View Answer


* You must be logged in to add comment.