Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

PostgreSQL PGCES-02 Exam - Topic 1 Question 97 Discussion

What happens if an SQL statement syntax error occurs while a transaction is running? Select the correct action from below.
C) The transaction is stopped and you cannot issue any SQL commands other than a command to end the transaction.
A) The transaction continues.
B) The transaction is aborted and a new transaction is started automatically.
D) The connection is terminated.
E) The 'postmaster' process is terminated.

PostgreSQL PGCES-02 Exam - Topic 1 Question 97 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 97
Topic #: 1
[All PGCES-02 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: C

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

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Rocco
I think it's C. The transaction stops, right?
upvoted 0 times
...
Rickie
5 days ago
B seems plausible too, but I think it's C.
upvoted 0 times
...
Elizabeth
10 days ago
Wait, are you sure about that? Sounds a bit harsh.
upvoted 0 times
...
Noah
15 days ago
Definitely agree with C, that's how it works!
upvoted 0 times
...
Anna
2 months ago
I thought it would just continue, but C makes sense.
upvoted 0 times
...
Leslee
2 months ago
C is the right answer, the transaction gets stopped.
upvoted 0 times
...
Enola
3 months 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
...
Carole
3 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
...
Kristofer
3 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
...
Carlton
3 months ago
I think I remember that if there's a syntax error, the transaction doesn't just keep going, right?
upvoted 0 times
...

Save Cancel