PostgreSQL PGCES-02 Exam - Topic 9 Question 27 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 27
Topic #: 9

[All PGCES-02 Questions]

Select a correct SQL command to change existing user "george"'s password to "foobar".

AALTER USER george WITH PASSWORD 'foobar';

BALTER USER george CHANGE PASSWORD 'foobar';

CALTER USER george SET PASSWORD 'foobar';

DSET USER george PASSWORD TO 'foobar';

ESET USER george ALTER PASSWORD 'foobar';

Show Suggested Answer

Suggested Answer: A

by Johnetta at Jun 17, 2022, 04:39 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Sharita

7 months ago

Wait, is A really the correct one? Sounds too simple!

upvoted 0 times

...

Dustin

7 months ago

D looks wrong, not a valid syntax.

upvoted 0 times

...

Britt

7 months ago

C seems off to me.

upvoted 0 times

...

Joseph

7 months ago

I thought it was B at first.

upvoted 0 times

...

Dana

7 months ago

A is the right command!

upvoted 0 times

...

Eladia

8 months ago

I keep mixing up the commands; I thought "CHANGE PASSWORD" sounded familiar, but it might not be correct for this SQL version.

upvoted 0 times

...

Gerri

8 months ago

I thought "SET PASSWORD" was used in some contexts, but I don't think that's the right format here.

upvoted 0 times

...

Blondell

8 months ago

I think it's option A, but I'm not completely sure if "WITH" is the right keyword for changing a password.

upvoted 0 times

...

Kris

8 months ago

I remember practicing a similar question, and I feel like "ALTER USER" is definitely involved, but I can't recall the exact syntax.

upvoted 0 times

...

Berry

8 months ago

I've worked with HyperFlex before, so I'm pretty confident I can figure this out. The minimum number of trunk interfaces is 2, I believe.

upvoted 0 times

...

Lacresha

8 months ago

Ah, this is a good one. Gotta make sure I don't mix up the NHRP functions across the different DMVPN phases. Redirect and resolution reply, got it.

upvoted 0 times

...

Delmy

8 months ago

I'm pretty confident that the right answer is Impact analysis. That's the type of assessment we've been practicing in class.

upvoted 0 times

...