Which of the following commands will change a user's password?
A) ALTER USERNAME username IDENTIFIED BY newpassword;
B) ALTER USER username IDENTITY newpassword;
C) ALTER USER username IDENTIFIED BY newpassword;
D) ALTER USERNAME username PASSWORD newpassword;

Question

Quizplus · Accepted Answer

The correct syntax for changing a user's password in Oracle is ALTER USER username IDENTIFIED BY newpassword. Option A has incorrect syntax and the keyword PASSWORD is not used in Oracle for changing a user's password. Option B has a spelling error for the keyword IDENTITY, and it is not the correct keyword for changing a user's password in Oracle.

Which of the Following Commands Will Change a User's Password