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

15 days ago

A superuser with the power to change settings? I bet they're the ones who decide when to restart the database for 'maintenance'.

upvoted 0 times

...

20 days ago

Hmm, so the superuser settings don't stick around for other connections? That's a bit disappointing, but I guess it makes sense.

upvoted 0 times

...

1 months 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

7 days ago

User 1: Yes, it's important to be aware of the parameters that can't be set with the SET command.

upvoted 0 times

...

1 months ago

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

upvoted 0 times

...

2 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

...