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

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Cassandra

2 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

...

Pete

7 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

...

Vincenza

20 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

...

Wilbert

22 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

...

Simona

1 months ago

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

upvoted 0 times

Tamala

3 days ago

User 2: I agree, it's a great way to see everything at once.

upvoted 0 times

...

Kimberlie

6 days ago

User 1: Yeah, the SHOW ALL command is really handy for getting a full view of all the settings.

upvoted 0 times

...

Georgiann

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

...

Jamika

2 months ago

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

upvoted 0 times

...

Novella

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

...