nerdexam
PostgreSQL_CE

PGCES-02 · Question #68

Select two statements that the command below DOES NOT do. Note: $ is the command prompt. $ pg_dump -b -F c b > d

The correct answer is A. Backs up the "b" database to the "c" file, and stores error messages to the "d" file. D. Backs up the "c" database to the "d" file as the "c" user. See the full explanation below for the reasoning.

Question

Select two statements that the command below DOES NOT do. Note: $ is the command prompt. $ pg_dump -b -F c b > d

Options

  • ABacks up the "b" database to the "c" file, and stores error messages to the "d" file.
  • BBacks up the "b" database to the "d" file.
  • CBacks up large objects.
  • DBacks up the "c" database to the "d" file as the "c" user.
  • ECreates a backup, which is restorable with thepg_restore command.

How the community answered

(23 responses)
  • A
    83% (19)
  • B
    9% (2)
  • C
    4% (1)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice