PostgreSQL Exam PGCES-02 Topic 2 Question 65 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 65
Topic #: 2

[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 Ora at Jun 30, 2024, 10:22 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Casandra

3 months ago

Option A is the clear choice. Although, I'm wondering if 'foobar' is a secure enough password. Maybe I should suggest 'hunter2' instead.

upvoted 0 times

Shalon

2 months ago

Good idea, let's go with 'hunter2' for better security.

upvoted 0 times

...

Deonna

3 months ago

Maybe we should suggest a stronger password like 'hunter2' instead of 'foobar'.

upvoted 0 times

...

Kimbery

3 months ago

I agree, 'ALTER USER george WITH PASSWORD 'foobar';' is the correct command.

upvoted 0 times

...

Leoma

3 months ago

Option A is the clear choice.

upvoted 0 times

...

Mireya

4 months ago

If I had a dollar for every time I saw a password change question on an exam, I'd be a millionaire! Option A is the winner.

upvoted 0 times

Bo

2 months ago

C) ALTER USER george SET PASSWORD 'foobar';

upvoted 0 times

...

Helaine

3 months ago

I agree, option A is the correct SQL command.

upvoted 0 times

...

Adolph

3 months ago

A) ALTER USER george WITH PASSWORD 'foobar';

upvoted 0 times

...

Carrol

3 months ago

I always get nervous when I see password change questions on exams.

upvoted 0 times

...

Jamey

3 months ago

I agree, option A is the correct SQL command.

upvoted 0 times

...

Phuong

3 months ago

Option A) ALTER USER george WITH PASSWORD 'foobar';

upvoted 0 times

...

Brittni

4 months ago

I think D) SET USER george PASSWORD TO 'foobar'; is incorrect because it doesn't follow the standard SQL syntax for altering user passwords.

upvoted 0 times

...

Tijuana

4 months ago

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

upvoted 0 times

...

Kimberlie

4 months ago

Choosing the right answer is like finding a needle in a haystack. Option A is definitely the way to go here.

upvoted 0 times

Chantay

4 months ago

Let's go with option A, ALTER USER george WITH PASSWORD 'foobar';

upvoted 0 times

...

Loren

4 months ago

I'm not sure, but ALTER USER george WITH PASSWORD 'foobar'; sounds correct.

upvoted 0 times

...

Rex

4 months ago

I agree, ALTER USER george WITH PASSWORD 'foobar'; is the right choice.

upvoted 0 times

...

Yuette

4 months ago

I think option A is the correct SQL command.

upvoted 0 times

...

Myrtie

4 months ago

I was going to choose Option C, but then I remembered that 'SET PASSWORD' is for the current user, not a specific user. Good catch on Option A!

upvoted 0 times

...

Lorrine

5 months ago

I agree with Leoma, A) makes sense because it uses the correct syntax for altering a user's password.

upvoted 0 times

...

Estrella

5 months ago

Option A is the correct SQL command to change the user's password. It's straightforward and follows the syntax.

upvoted 0 times

Shawna

4 months ago

That's correct! Option A is the right SQL command to change the password for user 'george'.

upvoted 0 times

...

Edgar

4 months ago

A) ALTER USER george WITH PASSWORD 'foobar';

upvoted 0 times

...

Leoma

5 months ago

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

upvoted 0 times

...