Loops MCQ Questions And Answers
Loops MCQs : This section focuses on "Loops" 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 ______ statement allows us to execute a statement or group of statements multiple times.
A. condition
B. loop
C. array
D. procedure
View Answer
Ans : B
Explanation: A loop statement allows us to execute a statement or group of statements multiple times.
2. Sequence of statements is enclosed between the LOOP and the END LOOP statements.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, sequence of statements is enclosed between the LOOP and the END LOOP statements.
3. The label should be enclosed by ?
A. single angle brackets
B. double dollar sign
C. double angle brackets
D. single dollar sign
View Answer
Ans : C
Explanation: The label should be enclosed by double angle brackets.
4. Label appear at the ________ of the LOOP statement.
A. end
B. beginning
C. anywhere
D. Can not say
View Answer
Ans : B
Explanation: Label appear at the beginning of the LOOP statement.
5. A ______ LOOP statement in PL/SQL programming language repeatedly executes a target statement as long as a given condition is true.
A. BASIC
B. FOR
C. Both A and B
D. WHILE
View Answer
Ans : D
Explanation: A WHILE LOOP statement in PL/SQL programming language repeatedly executes a target statement as long as a given condition is true.
6. Does PL/SQL allows using one loop inside another loop.
A. Yes
B. No
C. Can be yes or no
D. Can not say
View Answer
Ans : A
Explanation: Yes, PL/SQL allows using one loop inside another loop.
7. PL/SQL Loops are also known as
A. Iterative Case Statements
B. Iterative Control Statements
C. Indentation Control Statements
D. Indentation Case Statements
View Answer
Ans : B
Explanation: PL/SQL Loops are also known as Iterative Control Statements.
8. What is the syntax of PL/SQL Loop?
A. LOOP
END LOOP;
Sequence of statements;
B. END LOOP;
LOOP
Sequence of statements;
C. LOOP
Sequence of statements;
END LOOP;
D. END LOOP;
Sequence of statements;
LOOP
View Answer
Ans : C
Explanation: LOOP
Sequence of statements;
END LOOP;
9. How many types of PL/SQL Loops are there?
A. 1
B. 2
C. 3
D. 4
View Answer
Ans : D
Explanation: There are 4 types of PL/SQL loops.
10. PL/SQL loops can be labeled.
A. Yes
B. No
C. Can be yes or no
D. Can not say
View Answer
Ans : A
Explanation: Yes, PL/SQL loops can be labeled.
Discussion