PostgreSQL Exam PGCES-02 Topic 9 Question 56 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 56
Topic #: 9

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 Harrison at Mar 11, 2024, 02:15 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

6 months ago

I see your point, but I still think A) is the most straightforward command.

upvoted 0 times

...

6 months ago

I'm not so sure, I think C) ALTER USER george SET PASSWORD 'foobar'; might also be correct.

upvoted 0 times

...

6 months ago

I agree with Domitila, option A) seems like the right one.

upvoted 0 times

...

7 months ago

I think the correct answer is A) ALTER USER george WITH PASSWORD 'foobar';

upvoted 0 times

...