PostgreSQL PGCES-02 Exam - Topic 1 Question 97 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 97
Topic #: 1

What happens if an SQL statement syntax error occurs while a transaction is running? Select the correct action from below.

AThe transaction continues.

BThe transaction is aborted and a new transaction is started automatically.

CThe transaction is stopped and you cannot issue any SQL commands other than a command to end the transaction.

DThe connection is terminated.

EThe 'postmaster' process is terminated.

Show Suggested Answer

Suggested Answer: C

by Ezekiel at Apr 02, 2026, 04:58 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!