nerdexam
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)
  • A
    6% (3)
  • B
    2% (1)
  • C
    82% (40)
  • D
    8% (4)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice