nerdexam
PostgreSQL_CE

PGCES-02 · Question #27

Select one incorrect description about changing the settings of PostgreSQL during operation.

The correct answer is D. Values set by a superuser using the SET command are valid for different connections made. See the full explanation below for the reasoning.

Question

Select one incorrect description about changing the settings of PostgreSQL during operation.

Options

  • AThe current value of a parameter can be confirmed using the SHOW command.
  • BAll of the current settings can be displayed using the SHOW ALL command.
  • CChanges that can be made using the SET command have higher priority than ones in
  • DValues set by a superuser using the SET command are valid for different connections made
  • EThere are parameters that can not be set using the SET command

How the community answered

(45 responses)
  • A
    4% (2)
  • B
    11% (5)
  • C
    2% (1)
  • D
    80% (36)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice