PostgreSQL_CE
PGCES-02 · Question #8
What happens if an SQL statement syntax error occurs while a transaction is running? Select the correct action from below.
The correct answer is C. The transaction is stopped and you cannot issue any SQL commands other than a command. See the full explanation below for the reasoning.
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.
How the community answered
(49 responses)- A6% (3)
- B2% (1)
- C82% (40)
- D8% (4)
- E2% (1)
Community Discussion
No community discussion yet for this question.