PostgreSQL_CE

PGCES-02 · Question #71

Select a correct SQL command to change existing user "george"'s password to "foobar".

The correct answer is A. ALTER USERgeorge WITH PASSWORD 'foobar'. See the full explanation below for the reasoning.

Question

Select a correct SQL command to change existing user "george"'s password to "foobar".

Options

AALTER USERgeorge WITH PASSWORD 'foobar';
BALTER USERgeorge CHANGE PASSWORD 'foobar';
CALTER USERgeorge SET PASSWORD 'foobar';
DSET USERgeorge PASSWORD TO 'foobar';
ESET USERgeorge ALTER PASSWORD 'foobar';

How the community answered

(32 responses)

A
78% (25)
B
6% (2)
C
3% (1)
D
9% (3)
E
3% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full PGCES-02 Practice