[Solved] What is the primary role of a trigger used for data validation in PostgreSQL? — Ans: To automatically check and enforce rules before or after data changes | PostgreSQL

PostgreSQL - Triggers in PostgreSQL

What is the primary role of a trigger used for data validation in PostgreSQL?

ATo speed up query execution by caching results

BTo automatically check and enforce rules before or after data changes

CTo create new tables automatically

DTo backup the database periodically

Step-by-Step Solution

Solution:

Step 1: Understand what triggers do
Triggers run automatically when data changes happen in a table.
Step 2: Identify the role of triggers in validation
They check data against rules before or after insert, update, or delete operations.
Final Answer:
To automatically check and enforce rules before or after data changes -> Option B
Quick Check:
Trigger purpose = Data validation [OK]

Quick Trick: Triggers run automatically to enforce data rules [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the primary role of a trigger used for data validation in PostgreSQL?