MENU
What does the following command do? Choose two incorrect statements from the selection below. Note: $ is the command prompt. $ pg_restore -U postgres -d database1 database1.dump
Suggested Answer: A
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
35 comments · newest first
AD
Adela
11 months ago
Wait, can pg_restore really run without the postmaster?
LO
Lovetta
11 months ago
E is definitely incorrect, the database can exist.
JE
Jettie
11 months ago
D seems off, I thought it could restore large objects.
LE
Levi
11 months ago
B is true too, connects as postgres.
KI
Kina
12 months ago
A is correct, it restores the database.
AL
Alfred
12 months ago
A seems right, but I feel uncertain about C. I thought the postmaster had to be running for most operations, but maybe not for restores?
HA
Harris
12 months ago
I practiced a similar question, and I think D is incorrect because pg_restore can handle large objects. E sounds wrong too, but I can't recall the exact rules about existing databases.
DE
Dell
1 year ago
I think B is definitely true since it specifies the user 'postgres', but I'm a bit confused about C. Does the postmaster need to be running for all database commands?
VA
Val
1 year ago
I remember that pg_restore is used to restore databases, so A seems correct. But I'm not sure about E; can we restore to an existing database?
MO
Monte
1 year ago
Hmm, I'm not totally sure about this one. I know defined contribution plans are different from defined benefit plans, but I can't remember which party takes on the risk. I'll have to think this through carefully.
AN
Annett
1 year ago
This seems like a classic case of operant conditioning. I'm pretty confident the answer is D - Mrs. Carr has negatively reinforced Jack's interrupting behavior by giving in and playing with him when he screams.
MA
Ma
1 year ago
Wait, so we're supposed to choose the incorrect statements? This exam is like a game of 'Reverse Psychology: The Questionnaire'. I'm just going to pick the ones that sound the most right and see what happens.
WI
Wilda
1 year ago
Ooh, this is a good one! I'm going to go with C and E as the incorrect answers. Of course the postmaster needs to be running, and I don't need to worry about the database not existing. This is just a basic pg_restore command, right?
MI
Mitsue
1 year ago
I'm going with C and D as the incorrect statements. The postmaster needs to be running, and pg_restore can definitely handle large objects. Looks like the exam writers are trying to catch us with some tricky options.
VE
Veronika
1 year ago
It's always good to be careful with tricky options on exams. But it looks like we've got this one figured out.
GL
Glendora
1 year ago
Definitely! It's important to read the questions carefully and not get caught up in the tricky options.
BE
Beth
1 year ago
Yeah, I agree. And pg_restore can definitely handle large objects, so D is definitely incorrect.
GA
Gail
1 year ago
Yeah, the exam writers are trying to trick us with those options. Good thing we caught that!
CO
Corazon
1 year ago
I agree, C is definitely wrong. And pg_restore can handle large objects, so D is incorrect as well.
RO
Roxane
1 year ago
I think you're right, C and D seem like the incorrect statements. The postmaster does need to be running for the command to work.
JA
Jannette
1 year ago
I think C and D are incorrect too. The postmaster needs to be running for the command to work.
FE
Fernanda
1 year ago
Hah, E is clearly the wrong answer. Why would I need to make sure the database doesn't exist? That's just silly. This exam is testing my PostgreSQL knowledge, not my ability to state the obvious.
CA
Caitlin
1 year ago
User1: Exactly, it's more about understanding how to use pg_restore and connect to the database.
DO
Dominque
1 year ago
User2: I agree, that's a strange requirement. It's definitely not necessary for the command to work.
AN
Antione
1 year ago
User1: E is definitely a wrong answer. It doesn't make sense to check if the database exists before restoring it.
YV
Yvonne
2 years ago
A and B are correct, but C and D? Really? Everyone knows the postmaster needs to be running and that pg_restore can handle large objects. These options are just trying to trip me up!
AR
Aretha
1 year ago
It's important to read the question carefully before selecting an answer.
PA
Pamella
1 year ago
I always have to double check those tricky questions.
BE
Benton
1 year ago
Yeah, they are definitely trying to trick you with those incorrect statements.
VI
Viva
1 year ago
Yeah, they are definitely trying to trick us.
GA
Galen
1 year ago
I agree, those options are misleading.
LE
Leatha
1 year ago
I agree, those options are misleading.
CA
Carmen
2 years ago
I think the correct statements are A and D because it cannot restore large objects.
JA
Janine
2 years ago
I disagree, I believe the correct statements are A and E.
GL
Glendora
2 years ago
I think the correct statements are A and B.