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?
- ALTER USER user_name IDENTIFIED BY old_password;
- ALTER user_name IDENTIFIED BY new_password;
- ALTER USER user_name new_password;
- 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;