nerdexam
PostgreSQL_CE

PGCES-02 · Question #4

I would like to copy a database cluster directory for backup. Select two incorrect statements from below.

The correct answer is D. A database cluster that has been restored can be used on a newer version of PostgreSQL. E. A database cluster that has been restored can be used on an older version of PostgreSQL. See the full explanation below for the reasoning.

Question

I would like to copy a database cluster directory for backup. Select two incorrect statements from below.

Options

  • AThe directory must be copied after stopping the database server.
  • BWhen using the Tablespace function, it is necessary to back up the directory that stores the
  • CA database cluster that has been restored can be used on a separate machine with the same
  • DA database cluster that has been restored can be used on a newer version of PostgreSQL.
  • EA database cluster that has been restored can be used on an older version of PostgreSQL.

How the community answered

(32 responses)
  • A
    6% (2)
  • B
    9% (3)
  • C
    3% (1)
  • D
    81% (26)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice