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

18 days ago

I thought it would just continue, but C makes sense.

upvoted 0 times

...

23 days ago

C is the right answer, the transaction gets stopped.

upvoted 0 times

...

1 month ago

I’m confused about whether the connection gets terminated or if it just stops the transaction. I need to double-check that part!

upvoted 0 times

...

2 months ago

I’m leaning towards option C because I recall that you can’t run other SQL commands until you handle the error.

upvoted 0 times

...

2 months ago

I feel like I saw a similar question where the transaction was aborted, but I'm not entirely sure if it starts a new one automatically.

upvoted 0 times

...

2 months ago

I think I remember that if there's a syntax error, the transaction doesn't just keep going, right?

upvoted 0 times

...