There are ______ types of loops in PL/SQL

  1. 1

  2. 3

  3. 2

  4. 4


Correct Option: B

AI Explanation

To answer this question, you need to have knowledge of the types of loops in PL/SQL. Let's go through each option to understand why it is correct or incorrect:

Option A) 1 - This option is incorrect because there are more than one type of loop in PL/SQL. Option B) 3 - This option is correct because there are indeed three types of loops in PL/SQL. Option C) 2 - This option is incorrect because there are more than two types of loops in PL/SQL. Option D) 4 - This option is incorrect because there are not four types of loops in PL/SQL.

The correct answer is B. There are three types of loops in PL/SQL, which are:

  1. FOR loop: This loop is used to iterate over a specific range of values or a collection.
  2. WHILE loop: This loop is used to repeatedly execute a set of statements as long as a certain condition is true.
  3. LOOP-EXIT loop: This loop is used to perform an infinite loop until an exit condition is met using the EXIT statement.

Therefore, the correct answer is B) 3.

Find more quizzes: