Oracle Exam 1Z0-888 Topic 9 Question 31 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 31
Topic #: 9

You have created a new user with this statement:

CREATE USER 'erika'@'localhost' IDENTIFIED BY 'first#1Pass' PASSWORD EXPIRE;

What is the outcome?

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 ant 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.

Show Suggested Answer

Suggested Answer: A

by Annmarie at May 06, 2022, 02:36 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-888 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!