Home » MCQs » Oracle MCQs » Oracle Change Password, Check Constraints, Comments, and Primary Key MCQs

What is the syntax to Change Password?

2. What is the syntax to Change Password?

1. ALTER USER user_name IDENTIFIED BY old_password;
2. ALTER user_name IDENTIFIED BY new_password;
3. ALTER USER user_name new_password;
4. ALTER USER user_name IDENTIFIED BY new_password;

Answer: D) ALTER USER user_name IDENTIFIED BY new_password;

Explanation:

The syntax to Change Password is:

ALTER USER user_name IDENTIFIED BY new_password;