nerdexam
PostgreSQL_CE

PGCES-02 · Question #64

Select two correct statements about the command shown below. Note: $ is the command prompt. $ vacuumdb -az

The correct answer is A. Recovers unused areas from all of the databases. B. Collects statistical information related to the table content for all of the databases. See the full explanation below for the reasoning.

Question

Select two correct statements about the command shown below. Note: $ is the command prompt. $ vacuumdb -az

Options

  • ARecovers unused areas from all of the databases.
  • BCollects statistical information related to the table content for all of the databases.
  • CProcesses the job equivalent of the VACUUM FULL command for all of the databases.
  • DProcesses the job equivalent of the VACUUM VERBOSE command for all of the databases.
  • EThe database can not be accessed until this command is finished.

How the community answered

(17 responses)
  • A
    71% (12)
  • C
    6% (1)
  • D
    18% (3)
  • E
    6% (1)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice