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

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

upvoted 0 times

...

14 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

...

15 days ago

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

upvoted 0 times

...

16 days 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

...