MENU
What happens if an SQL statement syntax error occurs while a transaction is running? Select the correct action from below.
Suggested Answer: C
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
MA
Marnie
3 months ago
But what if it’s B? A new transaction starts automatically. That sounds possible.
CY
Cyndy
3 months ago
Yeah, I agree with C. No more SQL commands allowed.
RO
Rocco
3 months ago
I think it's C. The transaction stops, right?
RI
Rickie
3 months ago
B seems plausible too, but I think it's C.
EL
Elizabeth
3 months ago
Wait, are you sure about that? Sounds a bit harsh.
NO
Noah
4 months ago
Definitely agree with C, that's how it works!
AN
Anna
5 months ago
I thought it would just continue, but C makes sense.
LE
Leslee
5 months ago
C is the right answer, the transaction gets stopped.
EN
Enola
6 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!
CA
Carole
6 months ago
I’m leaning towards option C because I recall that you can’t run other SQL commands until you handle the error.
KR
Kristofer
6 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.
CA
Carlton
6 months ago
I think I remember that if there's a syntax error, the transaction doesn't just keep going, right?