Oracle Exam 1Z0-908 Topic 2 Question 90 Discussion

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

Question #: 90
Topic #: 2

[All 1Z0-908 Questions]

MySQL is installed on a Linux server with this configuration:

Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

ASet validate-user-plugins=caching_sha2_password in the configuration file.

BDefine CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.

CAdd default_authentication_plugin=mysql_native_password in the configuration file.

DAdd default_authentication_plugin=sha256_password in the configuration file.

Show Suggested Answer

Suggested Answer: D

by Kristel at Sep 17, 2024, 03:06 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Iraida

7 months ago

Option A looks like it might be a trick question. Validating user plugins is not the same as setting the default authentication method, is it?

upvoted 0 times

...

Izetta

7 months ago

I see your point, but I still think A is the best choice because it specifically mentions SHA-256 hashing.

upvoted 0 times

...

Hah, I bet the developers who came up with these authentication methods had a field day coming up with the names. 'caching_sha2_password' and 'sha256_password' sound like they were generated by a random password generator!

upvoted 0 times

Clement

6 months ago

upvoted 0 times

...

Gilberto

6 months ago

C) Add default_authentication_plugin=mysql_native_password in the configuration file.

upvoted 0 times

...

Jose

7 months ago

A) Set validate-user-plugins=caching_sha2_password in the configuration file.

upvoted 0 times

...

Hui

7 months ago

I disagree, I believe the correct answer is D) Add default_authentication_plugin=sha256_password in the configuration file.

upvoted 0 times

...

Adaline

7 months ago

I would go with option B. Defining 'CREATE USER ''@'%' IDENTIFIED WITH sha256_password' directly in the MySQL instance seems like the most direct way to achieve the desired authentication method.

upvoted 0 times

Nelida

6 months ago

I'm leaning towards option C. Adding default_authentication_plugin=mysql_native_password in the configuration file might be the way to set the default authentication to SHA-256 hashing.

upvoted 0 times

...

Laurel

6 months ago

I see your point, but I still think option B is the best. Defining 'CREATE USER ''@'%' IDENTIFIED WITH sha256_password' directly in the MySQL instance seems like the most direct way.

upvoted 0 times

...

Ty

7 months ago

I disagree, I believe option D is the correct choice. Adding default_authentication_plugin=sha256_password in the configuration file seems more appropriate.

upvoted 0 times

...

Antione

7 months ago

I think option A is the way to go. Setting validate-user-plugins=caching_sha2_password in the configuration file should do the trick.

upvoted 0 times

...

Izetta

8 months ago

I think the answer is A) Set validate-user-plugins=caching_sha2_password in the configuration file.

upvoted 0 times

...

Rana

8 months ago

Option D seems straightforward to me. Adding 'default_authentication_plugin=sha256_password' in the configuration file should set the default authentication to SHA-256 hashing.

upvoted 0 times

Daniela

7 months ago

Yeah, adding 'default_authentication_plugin=sha256_password' should do the trick.

upvoted 0 times

...

Jenelle

7 months ago

I think option D is the correct one.

upvoted 0 times

...

Oracle Exam 1Z0-908 Topic 2 Question 90 Discussion

Contribute your Thoughts:

Iraida

Izetta

Deeanna

Clement

Gilberto

Jose

Hui

Adaline

Nelida

Laurel

Ty

Antione

Izetta

Rana

Daniela

Jenelle