Oracle
1Z0-888 · Question #47
1Z0-888 Question #47: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #47. The question stem and answer options stay visible for context.
Security
Question
You have created a new user with this statement:
CREATE USER 'erika'@'localhost' IDENTIFIED BY 'first#1Pass' PASSWORD EXPIRE;
What is the outcome?Options
- AWhen 'erika'@'localhost' tries to log in with the MySQL command-line client, the user will have to change the password before seeing the MySQL> prompt.
- BWhen 'erika'@'localhost' tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.
- CWhen 'erika'@'localhost' tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue any statements until the user changes the password.
- DYou receive a syntax error that indicates that you cannot set a password and expire it at the same time.
Unlock 1Z0-888 to see the answer
You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#User Management#Password Expiration#Authentication#CREATE USER