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:
- FOR loop: This loop is used to iterate over a specific range of values or a collection.
- WHILE loop: This loop is used to repeatedly execute a set of statements as long as a certain condition is true.
- 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.