New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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".

Show Suggested Answer Hide 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
3 months ago
E) SET USER george ALTER PASSWORD 'foobar';
upvoted 0 times
...
Maddie
3 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
4 months ago
Yes, option C is the standard way to set a new password for a user in SQL.
upvoted 0 times
...
Carlee
4 months ago
I agree, option C is the correct SQL command to change the password for user 'george'.
upvoted 0 times
...
...
Kendra
5 months ago
I think D) SET USER george PASSWORD TO 'foobar'; is the correct command based on my experience.
upvoted 0 times
...
Elinore
5 months ago
I'm not sure, but I think C) ALTER USER george SET PASSWORD 'foobar'; could also be correct.
upvoted 0 times
...
Toshia
5 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
4 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
5 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
4 months ago
Yes, that's the correct SQL command to change the password for user 'george'.
upvoted 0 times
...
Cristal
4 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
5 months ago
C) ALTER USER george SET PASSWORD 'foobar';
upvoted 0 times
...
Matilda
5 months ago
B) ALTER USER george CHANGE PASSWORD 'foobar';
upvoted 0 times
...
Alison
5 months ago
A) ALTER USER george WITH PASSWORD 'foobar';
upvoted 0 times
...
...

Save Cancel