PostgreSQL Exam PGCES-02 Topic 9 Question 39 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 39
Topic #: 9

[All PGCES-02 Questions]

Select two transaction isolation levels supported in PostgreSQL.

ADIRTY READ

BREAD COMMITTED

CREPEATABLE READ

DPHANTOM READ

ESERIALIZABLE

Show Suggested Answer

Suggested Answer: A, E

by Ernest at Feb 07, 2023, 08:34 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Arlette

8 days ago

Hmm, B and E seem like the correct answers here. I'm pretty sure DIRTY READ is not an actual isolation level, and PHANTOM READ is just a phenomenon that can occur in certain isolation levels.

upvoted 0 times

...

Gracie

15 days ago

I'm not sure about the other options, but I know that READ COMMITTED and SERIALIZABLE are commonly used in PostgreSQL for managing transactions.

upvoted 0 times

...

Moon

18 days ago

I agree with Shizue. READ COMMITTED and SERIALIZABLE are the correct options. They provide different levels of consistency and concurrency control.

upvoted 0 times

...

Shizue

19 days ago

I think the two transaction isolation levels supported in PostgreSQL are READ COMMITTED and SERIALIZABLE.

upvoted 0 times

...