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

Yvonne

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

...