PostgreSQL Exam PGCES-02 Topic 5 Question 47 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 47
Topic #: 5

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

AThis command restores the database database1 from the file database1.dump.

BThis command connects to a database as the user 'postgres'.

CThis command can not be executed unless the postmaster is running.

DThis command can not restore large objects.

EThis command must be executed under the condition where the database database1 does not exist.

Show Suggested Answer

Suggested Answer: A

by Tyra at Aug 08, 2023, 04:02 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Ma

2 months 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.

upvoted 0 times

...

Wilda

2 months 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?

upvoted 0 times

...

Mitsue

2 months 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.

upvoted 0 times

Veronika

28 days ago

It's always good to be careful with tricky options on exams. But it looks like we've got this one figured out.

upvoted 0 times

...

Glendora

29 days ago

Definitely! It's important to read the questions carefully and not get caught up in the tricky options.

upvoted 0 times

...

Beth

30 days ago

Yeah, I agree. And pg_restore can definitely handle large objects, so D is definitely incorrect.

upvoted 0 times

...

Gail

1 months ago

Yeah, the exam writers are trying to trick us with those options. Good thing we caught that!

upvoted 0 times

...

Corazon

1 months ago

I agree, C is definitely wrong. And pg_restore can handle large objects, so D is incorrect as well.

upvoted 0 times

...

Roxane

1 months 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.

upvoted 0 times

...

Jannette

2 months ago

I think C and D are incorrect too. The postmaster needs to be running for the command to work.

upvoted 0 times

...

Fernanda

3 months 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.

upvoted 0 times

Caitlin

1 months ago

User1: Exactly, it's more about understanding how to use pg_restore and connect to the database.

upvoted 0 times

...

Dominque

1 months ago

User2: I agree, that's a strange requirement. It's definitely not necessary for the command to work.

upvoted 0 times

...

Antione

2 months ago

User1: E is definitely a wrong answer. It doesn't make sense to check if the database exists before restoring it.

upvoted 0 times

...

Yvonne

3 months 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!

upvoted 0 times