PostgreSQL Exam PGCES-02 Topic 6 Question 67 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 67
Topic #: 6

[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 Janna at Jul 17, 2024, 04:19 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Wilburn

4 months ago

Haha, option D looks like something straight out of a comedy skit. 'Set user george password to foobar'? Really?

upvoted 0 times

Alberto

2 months ago

E) SET USER george ALTER PASSWORD 'foobar';

upvoted 0 times

...

Maddie

2 months ago

Haha, I agree, option D does sound pretty funny.

upvoted 0 times

...

Inocencia

3 months ago

C) ALTER USER george SET PASSWORD 'foobar';

upvoted 0 times

...

Jestine

3 months ago

A) ALTER USER george WITH PASSWORD 'foobar';

upvoted 0 times

...

Vivan

4 months ago

Option C is the way to go. The other choices look a bit too creative or unconventional for a certification exam.

upvoted 0 times

Hoa

3 months ago

Yes, option C is the standard way to set a new password for a user in SQL.

upvoted 0 times

...

Carlee

3 months ago

I agree, option C is the correct SQL command to change the password for user 'george'.

upvoted 0 times

...

Kendra

4 months ago

I think D) SET USER george PASSWORD TO 'foobar'; is the correct command based on my experience.

upvoted 0 times

...

Elinore

4 months ago

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

upvoted 0 times

...

Toshia

4 months ago

I'm going with C as well. It's the only one that looks like the proper SQL syntax for this task.

upvoted 0 times

Kaycee

3 months ago

Yes, ALTER USER george WITH PASSWORD 'foobar'; is the correct syntax to change the password.

upvoted 0 times

...

Rose

4 months ago

I agree, A) looks like the right SQL command to change the password for user 'george'.

upvoted 0 times

...

Tammara

4 months ago

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

upvoted 0 times

...

Otis

4 months ago

Definitely C. Changing a user's password is a pretty standard SQL operation, and the syntax is well-documented.

upvoted 0 times

Pansy

3 months ago

Yes, that's the correct SQL command to change the password for user 'george'.

upvoted 0 times

...

Cristal

3 months ago

C) ALTER USER george SET PASSWORD 'foobar';

upvoted 0 times

...

Lonna

4 months ago

No, that's not the correct syntax for changing a user's password.

upvoted 0 times

...

Iluminada

4 months ago

A) ALTER USER george WITH PASSWORD 'foobar';

upvoted 0 times

...

Teri

5 months ago

I agree with Staci, option A seems to be the right SQL command.

upvoted 0 times

...

Staci

5 months ago

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

upvoted 0 times

...

Tina

5 months ago

Option C is the correct answer. The syntax for changing a user's password in SQL is 'ALTER USER SET PASSWORD 'new_password';'.

upvoted 0 times

Roy

4 months ago

C) ALTER USER george SET PASSWORD 'foobar';

upvoted 0 times

...

Matilda

4 months ago

B) ALTER USER george CHANGE PASSWORD 'foobar';

upvoted 0 times

...

Alison

4 months ago

A) ALTER USER george WITH PASSWORD 'foobar';

upvoted 0 times

...