PostgreSQL Exam PGCES-02 Topic 4 Question 63 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 63
Topic #: 4

[All PGCES-02 Questions]

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

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 postgresql.conf.

DValues set by a superuser using the SET command are valid for different connections made later.

EThere are parameters that can not be set using the SET command

Show Suggested Answer

Suggested Answer: A, C

by Tamie at May 29, 2024, 10:48 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

1 days ago

Aha, good to know there are some parameters that can't be set with the SET command. Gotta keep an eye on those.

upvoted 0 times

...

3 days ago

Wait, so the SET command overrides the postgresql.conf file? That seems a bit too powerful if you ask me.

upvoted 0 times

...

15 days ago

That SHOW ALL command sounds pretty useful! I bet it would give me a comprehensive overview of all the settings.

upvoted 0 times

...

28 days ago

I believe option D is incorrect because changes made using the SET command are only temporary and do not persist for future connections.

upvoted 0 times

...

29 days ago

I agree with Novella. The SET command values are only valid for the current session, not for later connections.

upvoted 0 times

...

1 months ago

I think the incorrect description is D) Values set by a superuser using the SET command are valid for different connections made later.

upvoted 0 times

...