Explore topic-wise MCQs in PL/SQL (MCQ) questions and answers.

This section includes 2 Mcqs, each offering curated multiple-choice questions to sharpen your PL/SQL (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.

1.	DECLARE v_start_sales NUMBER := 2;v_end_sales NUMBER := 100;BEGINFOR i IN v_start_sales..v_end_sales LOOPINSERT INTO messages(msgid)VALUES v_start_sales;END LOOP;END;
A.	0
B.	99
C.	1
D.	100
Answer» C. 1

Discussion

2.	What is the maximum number of ELSE clauses that can be included in an IF clause that is not nested?
A.	1
B.	0
C.	15
D.	Any number
Answer» B. 0

Discussion

Explore topic-wise MCQs in PL/SQL (MCQ) questions and answers.

DECLARE v_start_sales NUMBER := 2;v_end_sales NUMBER := 100;BEGINFOR i IN v_start_sales..v_end_sales LOOPINSERT INTO messages(msgid)VALUES v_start_sales;END LOOP;END;

What is the maximum number of ELSE clauses that can be included in an IF clause that is not nested?