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


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


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


4. Label appear at the ________ of the LOOP statement.

A. end
B. beginning
C. anywhere
D. Can not say

View Answer


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


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


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


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


9. How many types of PL/SQL Loops are there?

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

View Answer


10. PL/SQL loops can be labeled.

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

View Answer





Discussion


* You must be logged in to add comment.