[Solved] What is the main purpose of a trigger in PostgreSQL for audit logging? — Ans: To automatically record changes made to data in a table | PostgreSQL

PostgreSQL - Triggers in PostgreSQL

What is the main purpose of a trigger in PostgreSQL for audit logging?

ATo backup the database periodically

BTo automatically record changes made to data in a table

CTo create new tables automatically

DTo speed up query execution

Step-by-Step Solution

Solution:

Step 1: Understand what triggers do
Triggers run code automatically when data changes occur in a table.
Step 2: Connect triggers to audit logging
Audit logging means recording who changed what and when, which triggers help automate.
Final Answer:
To automatically record changes made to data in a table -> Option B
Quick Check:
Trigger = automatic audit record [OK]

Quick Trick: Triggers run code on data changes to log audits [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the main purpose of a trigger in PostgreSQL for audit logging?