PostgreSQL-CE PGCES-02 Online Practice Questions and Exam Preparation

PostgreSQL-CE PGCES-02 Online Questions & Answers

• Question 141:

  What does the following command do? Select the correct description from below. Note:

  "text=#" is the command prompt for psql.

  test=# ANALYZE foo;

  A. Collects statistical information related to the content of the database foo.
  B. Collects statistical information related to the content of the table foo.
  C. Collects statistical information related to the content of the database test.
  D. Outputs statistical information related to the content of the table foo.
  E. The command does not generate an error; however, it does not do anything either.
  B. Collects statistical information related to the content of the table foo.

• Question 142:

  Select two suitable statements about postgresql.conf configuration.

  A. A line that starts with ! (exclamation mark) is interpreted as a comment.
  B. You can have different parameters for the same option to configure each database differently.
  C. The timing of when a change in any value is reflected is different depending on the configuration parameter.
  D. All options have no default values. Therefore, all of them must be set specifically and thoroughly.
  E. As a boolean value, any of the following can be used: TRUE, FALSE, ON, OFF, YES, NO, 0.1
  C. The timing of when a change in any value is reflected is different depending on the configuration parameter.
  E. As a boolean value, any of the following can be used: TRUE, FALSE, ON, OFF, YES, NO, 0.1