PostgreSQL_CE
PGCES-02 · Question #8
PGCES-02 Question #8: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #8. The question stem and answer options stay visible for context.
Question
What happens if an SQL statement syntax error occurs while a transaction is running? Select the correct action from below.
Options
- 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
- DThe connection is terminated.
- EThe "postmaster" process is terminated.
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.