[Solved] What is the main purpose of a DO block in PostgreSQL? — Ans: To run anonymous procedural code immediately without creating a permanent... | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

What is the main purpose of a DO block in PostgreSQL?

ATo define a new permanent function

BTo create a new table in the database

CTo execute a SELECT query and return results

DTo run anonymous procedural code immediately without creating a permanent function

Step-by-Step Solution

Solution:

Step 1: Understand the role of DO blocks
DO blocks allow running procedural code immediately without saving it as a function.
Step 2: Compare with other options
Creating tables or functions is done with other commands, and DO blocks do not return query results.
Final Answer:
To run anonymous procedural code immediately without creating a permanent function -> Option D
Quick Check:
DO blocks = anonymous immediate code execution [OK]

Quick Trick: DO blocks run code immediately without saving functions [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the main purpose of a DO block in PostgreSQL?