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

5 days ago

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

upvoted 0 times

...

Vivan

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

...

Kendra

19 days ago

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

upvoted 0 times

...

Elinore

20 days ago

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

upvoted 0 times

...

Toshia

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

Rose

3 days ago

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

upvoted 0 times

...

Tammara

7 days ago

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

upvoted 0 times

...

Otis

26 days ago

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

upvoted 0 times

Lonna

9 days ago

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

upvoted 0 times

...

Iluminada

14 days ago

A) ALTER USER george WITH PASSWORD 'foobar';

upvoted 0 times

...

Teri

30 days ago

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

upvoted 0 times

...

Staci

1 months ago

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

upvoted 0 times

...

Tina

1 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

16 days ago

C) ALTER USER george SET PASSWORD 'foobar';

upvoted 0 times

...

Matilda

20 days ago

B) ALTER USER george CHANGE PASSWORD 'foobar';

upvoted 0 times

...

Alison

28 days ago

A) ALTER USER george WITH PASSWORD 'foobar';

upvoted 0 times

...