PostgreSQL Exam PGCES-02 Topic 10 Question 55 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 55
Topic #: 10

[All PGCES-02 Questions]

Select two SQL statements which abort a transaction.

AEND

BROLLBACK

CTRUNCATE

DABORT

EDROP TRANSTACTION

Show Suggested Answer

Suggested Answer: B, D

by Stephane at Feb 07, 2024, 07:24 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Mitsue

9 months ago

I don't think END aborts a transaction, Janey. I beliMitsue it just marks the end of a transaction without rolling it back.

upvoted 0 times

...

Janey

9 months ago

I'm not sure about this one. Isn't END also used to finish a transaction?

upvoted 0 times

...

Margart

10 months ago

I would also go with B) ROLLBACK. It makes sense to rollback a transaction if something goes wrong.

upvoted 0 times

...

Rikki

10 months ago

I agree with you, Tomas. ROLLBACK is commonly used to undo changes in a transaction.

upvoted 0 times

...

Tomas

10 months ago

I think the answer is B) ROLLBACK because it aborts a transaction.

upvoted 0 times

...

Hubert

10 months ago

Yeah, TRUNCATE is for deleting data, not for aborting transactions.

upvoted 0 times

...

Rhea

10 months ago

I don't think TRUNCATE aborts a transaction. It just removes all rows from a table quickly.

upvoted 0 times

...

Blondell

11 months ago

I'm not so sure about that. I think TRUNCATE can also abort a transaction.

upvoted 0 times

...

Hubert

11 months ago

I agree with Rhea. ROLLBACK and ABORT are used to abort a transaction in SQL.

upvoted 0 times

...

Rhea

11 months ago

I think the correct answers are B) ROLLBACK and D) ABORT.

upvoted 0 times

...