Which of the following SQL statements will change the password for user RTHOMAS to ANEW5PASSWORD
A) ALTER USER rthomas PASSWORD TO anew5password;
B) CHANGE USER rthomas IDENTIFIED BY anew5password;
C) MODIFY USER rthomas PASSWORD TO anew5password;
D) ALTER USER rthomas IDENTIFIED BY anew5password;

Question

Which of the following SQL statements will change the password for user RTHOMAS to ANEW5PASSWORD​
A) ​ALTER USER rthomas PASSWORD TO anew5password;
B) ​CHANGE USER rthomas IDENTIFIED BY anew5password;
C) ​MODIFY USER rthomas PASSWORD TO anew5password;
D) ​ALTER USER rthomas IDENTIFIED BY anew5password;

Quizplus · Accepted Answer

The correct syntax for changing a user's password in SQL is "ALTER USER <> IDENTIFIED BY <>". Therefore, the correct statement is D, "ALTER USER rthomas IDENTIFIED BY anew5password;".

Which of the Following SQL Statements Will Change the Password