nerdexam
PostgreSQL_CE

PGCES-02 · Question #41

What does the following command do? Choose the most appropriate statement from the selection below. Note: $ is the command prompt. $ pg_dump postgres > pgsql

The correct answer is A. Writes a backup of the database postgres to the file pgsql. See the full explanation below for the reasoning.

Question

What does the following command do? Choose the most appropriate statement from the selection below. Note: $ is the command prompt. $ pg_dump postgres > pgsql

Options

  • 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
  • EOutputs all of the content of the database postgres to the screen using the user pgsql.

How the community answered

(40 responses)
  • A
    78% (31)
  • B
    3% (1)
  • C
    5% (2)
  • D
    5% (2)
  • E
    10% (4)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice