nerdexam
PostgreSQL_CE

PGCES-02 · Question #37

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

The correct answer is D. This command can not restore large objects. E. This command must be executed under the condition where the database database1 does not. See the full explanation below for the reasoning.

Question

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

Options

  • 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

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    7% (2)
  • C
    4% (1)
  • D
    85% (23)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice