Oracle Exam 1Z0-888 Topic 4 Question 53 Discussion

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

Question #: 53
Topic #: 4

You have the following in your my.cnf configuration file:

[mysqld]

default_authentication_plugin=sha256_password

You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.

Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)

ACREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password 'imbatman';

BCREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';

CCREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY 'imbatman';

DCREATE USER WITH sha256_password 'sha256_user'@'192.0.2.10' IDENTIFIED AS 'webdesign' USING 'imbatman';

ECREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY 'imbatman';

FCREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';
References:

Show Suggested Answer

Suggested Answer: B, F

by Gwenn at May 06, 2022, 09:16 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!