[Solved] Which statement correctly describes a FOR loop in PostgreSQL? — Ans: It iterates over a range or query result set automatically | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Which statement correctly describes a FOR loop in PostgreSQL?

AIt only runs once and then stops

BIt iterates over a range or query result set automatically

CIt creates a new database schema

DIt deletes rows from a table

Step-by-Step Solution

Solution:

Step 1: Recall FOR loop behavior in PostgreSQL
A FOR loop automatically iterates over a range of numbers or rows from a query.
Step 2: Match the description with options
It iterates over a range or query result set automatically correctly states this automatic iteration, unlike other unrelated options.
Final Answer:
It iterates over a range or query result set automatically -> Option B
Quick Check:
FOR loop = automatic iteration [OK]

Quick Trick: FOR loops iterate over ranges or query results [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which statement correctly describes a FOR loop in PostgreSQL?