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

12 days 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

13 days 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

17 days 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

...

Fernanda

1 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

Antione

2 days 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

...

2 months ago

I think the correct statements are A and B.

upvoted 0 times

...