Which of the following is the correct syntax to start a LOOP block in PostgreSQL?

easy📝 Syntax Q3 of 15

PostgreSQL - PL/pgSQL Fundamentals

Which of the following is the correct syntax to start a LOOP block in PostgreSQL?

AFOR ... END FOR;

BWHILE ... END WHILE;

CLOOP ... END LOOP;

DBEGIN ... END;

Step-by-Step Solution

Solution:

Step 1: Recall PostgreSQL LOOP syntax
A LOOP block starts with LOOP and ends with END LOOP;.
Step 2: Compare options with correct syntax
Only LOOP ... END LOOP; matches the exact syntax for a LOOP block in PostgreSQL.
Final Answer:
LOOP ... END LOOP; -> Option C
Quick Check:
LOOP syntax = LOOP ... END LOOP; [OK]

Quick Trick: LOOP blocks end with END LOOP; [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free