MENU
Select two transaction isolation levels supported in PostgreSQL.
Suggested Answer: A, E
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
42 comments · newest first
IS
Isaac
11 months ago
Surprised to see PHANTOM READ mentioned, isn't that just a concept?
FA
Fabiola
11 months ago
REPEATABLE READ is definitely supported as well.
DO
Donette
12 months ago
Wait, I thought DIRTY READ was a thing too?
CO
Corinne
12 months ago
Totally agree, those are the main ones!
DI
Diego
12 months ago
READ COMMITTED and SERIALIZABLE are two levels in PostgreSQL.
MA
Mayra
1 year ago
I recall REPEATABLE READ being mentioned in class, but I can't remember if it was paired with SERIALIZABLE or something else.
BU
Buck
1 year ago
I’m a bit confused about DIRTY READ; I thought it was a concept but not an actual isolation level in PostgreSQL.
MA
Malika
1 year ago
I practiced a question like this, and I believe SERIALIZABLE is definitely one of the options.
FA
Fatima
1 year ago
I think I remember that READ COMMITTED is one of the isolation levels, but I'm not sure about the second one.
GL
Gladys
1 year ago
I'm pretty confident the answer is to revert to the latest snapshot. That's the typical way to restore a VM to a previous state, so I'm going with option B.
DE
Delsie
1 year ago
I'm pretty sure Part I describes the TOGAF approach to Enterprise Architecture, so I'll go with option A.
BL
Blair
1 year ago
Okay, I think I've got a strategy for this. I'll focus on the cost and availability of the materials to determine the best option.
AL
Alethea
1 year ago
I think one challenge is definitely reduced visibility due to NAT. That sounds familiar from our practice discussions.
NA
Nana
1 year ago
Hmm, this seems like a tricky one. I'll need to think it through carefully.
DO
Dortha
1 year ago
I think it's the "accept" and "relay" actions, but I'm not completely sure about "accept."
LE
Leonida
1 year ago
B and E for the win! Though I have to say, DIRTY READ sounds like something you'd find in a cheap detective novel, not a database manual.
EL
Eleonora
1 year ago
I always go for SERIALIZABLE when it comes to transaction isolation levels.
VI
Vivan
1 year ago
Yeah, DIRTY READ does sound like it belongs in a mystery novel.
GE
Gearldine
1 year ago
I agree, B and E are the way to go.
BE
Becky
1 year ago
Alright, time to put my PostgreSQL prowess to the test. I'm confident B and E are the correct answers here. Though I do wonder if DIRTY READ is a real thing, maybe it's some kind of avant-garde isolation level that never caught on.
CR
Craig
1 year ago
Yes, DIRTY READ is not a valid option, stick with B and E for the correct transaction isolation levels.
RA
Rachael
1 year ago
DIRTY READ is not one of the supported levels, so you can confidently go with B and E.
CA
Catarina
1 year ago
I think you're right, B and E are indeed supported isolation levels in PostgreSQL.
MA
Marjory
1 year ago
Ah, the age-old PostgreSQL isolation level question. B and E are the way to go, can't go wrong with the classics. Though I have to admit, PHANTOM READ does sound like something out of a horror movie.
KA
Kasandra
1 year ago
I always stick with READ COMMITTED and SERIALIZABLE for my transactions.
PA
Paris
1 year ago
Yeah, PHANTOM READ does sound a bit spooky, but it's not as commonly used in practice.
CL
Clorinda
1 year ago
I agree, READ COMMITTED and SERIALIZABLE are commonly used isolation levels.
TA
Tashia
1 year ago
Ha! DIRTY READ, really? Sounds like something my college roommate would've tried to pull off. I'm going with B and C, those are the legit ones I remember from my PostgreSQL studies.
AR
Arlette
1 year 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.
MA
Marge
1 year ago
Exactly, those are the two transaction isolation levels supported in PostgreSQL.
CH
Charlena
1 year ago
So, READ COMMITTED and SERIALIZABLE are the two correct options.
GR
Graciela
1 year ago
Yes, DIRTY READ is not a supported isolation level and PHANTOM READ is a phenomenon, not an isolation level.
DO
Dottie
1 year ago
I think you're right, B and E are the correct transaction isolation levels in PostgreSQL.
HA
Haley
1 year ago
So, the correct answers are B) READ COMMITTED and E) SERIALIZABLE.
CA
Cary
1 year ago
PHANTOM READ is indeed a phenomenon that can occur in certain isolation levels, but it's not one of the supported options.
AN
Angelica
1 year ago
Yeah, DIRTY READ is not a supported isolation level in PostgreSQL.
CO
Cordelia
1 year ago
Yeah, DIRTY READ is not an isolation level and PHANTOM READ is just a phenomenon.
MA
Markus
1 year ago
I think you're right, B) READ COMMITTED and E) SERIALIZABLE are the correct transaction isolation levels in PostgreSQL.
LU
Luisa
1 year ago
I think you're right, B and E are the correct ones.
GR
Gracie
2 years 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.
MO
Moon
2 years ago
I agree with Shizue. READ COMMITTED and SERIALIZABLE are the correct options. They provide different levels of consistency and concurrency control.
SH
Shizue
2 years ago
I think the two transaction isolation levels supported in PostgreSQL are READ COMMITTED and SERIALIZABLE.