nerdexam
PostgreSQL_CE

PGCES-02 · Question #34

What phenomenon occurs if PostgreSQL is used without performing VACUUM ? Select two appropriate descriptions from those below.

The correct answer is A. Performance is reduced. C. The physical size of the database increases considerably in size. See the full explanation below for the reasoning.

Question

What phenomenon occurs if PostgreSQL is used without performing VACUUM ? Select two appropriate descriptions from those below.

Options

  • APerformance is reduced.
  • BIt gradually gets tothe point where connections are denied.
  • CThe physical size of the database increases considerably in size.
  • DOnly SELECT queries will be accepted.
  • EAn e-mail prompting the administrator to perform VACUUM is sent from PostgreSQL.

How the community answered

(18 responses)
  • A
    78% (14)
  • B
    6% (1)
  • D
    11% (2)
  • E
    6% (1)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice