PostgreSQL PGCES-02 Exam - Topic 2 Question 96 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 96
Topic #: 2

[All PGCES-02 Questions]

What does the following command do? Choose the most appropriate statement from the selection below.

Note: $ is the command prompt.

$ pg_dump postgres > pgsql

AWrites a backup of the database postgres to the file pgsql.

BWrites a backup of the entire database cluster using user postgres to the file pgsql.

CBacks up the database postgres and writes an error message to the file pgsql.

DWrites a backup of the entire database cluster to the file postgres and writes an error message to the file pgsql.

EOutputs all of the content of the database postgres to the screen using the user pgsql.

Show Suggested Answer

Suggested Answer: A

by Veronica at Mar 05, 2026, 08:11 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!