Oracle Exam 1Z0-888 Topic 3 Question 94 Discussion

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

Question #: 94
Topic #: 3

You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)

AStart the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.

BStart the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.

CStart the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.

DStart the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.

EStart the MySQL Server with --initialize-insecure to force a password reset procedure on the command line.
References:

Show Suggested Answer

Suggested Answer: B

by Dorcas at Jun 22, 2024, 04:07 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Willard

9 months ago

Option C is the winner! -data-only is the way to go. Dumping just the userdata table's contents, no fuss, no muss. Now, where's the coffee refill station around here?

upvoted 0 times

Jesse

8 months ago

C) - -data-only as this specifies that only data is to be dumped

upvoted 0 times

...

Germaine

8 months ago

B) - -single-transaction as this obtains a consistent view of data only

upvoted 0 times

...

Davida

8 months ago

A) - -no-create-info to skip writing CREATE TABLE statements

upvoted 0 times

...

Winifred

8 months ago

C) - -data-only as this specifies that only data is to be dumped

upvoted 0 times

...

Hoa

8 months ago

B) - -single-transaction as this obtains a consistent view of data only

upvoted 0 times

...

Erinn

9 months ago

A) - -no-create-info to skip writing CREATE TABLE statements

upvoted 0 times

...

Ira

9 months ago

I agree with Norah, option C) seems to be the most appropriate for this scenario

upvoted 0 times

...

Norah

9 months ago

But - -data-only specifically mentions dumping only data, which is what the question asks for

upvoted 0 times

...

Chauncey

9 months ago

I think option D) - -table=userdata is also a valid choice

upvoted 0 times

...

Precious

10 months ago

Hah, I bet the exam writer is secretly a database admin with a wicked sense of humor. -data-only, of course! Wouldn't want to accidentally drop the whole table, now would we?

upvoted 0 times

William

9 months ago

C) - -data-only as this specifies that only data is to be dumped

upvoted 0 times

...

Susana

9 months ago

A) - -no-create-info to skip writing CREATE TABLE statements

upvoted 0 times

...

Norah

10 months ago

C) - -data-only as this specifies that only data is to be dumped

upvoted 0 times

...

Juan

10 months ago

Hmm, I was thinking option D would work, but now I'm not so sure. I guess -data-only is the way to go. Gotta love these MySQL dump commands, they're like a secret language!

upvoted 0 times

...

Bong

10 months ago

Option C looks good to me. -data-only is exactly what I need to dump just the data and not the table structure.

upvoted 0 times

Oneida

10 months ago

Yes, -data-only is the correct argument for dumping only data from the table.

upvoted 0 times

...

Leah

10 months ago

Option C looks good to me. -data-only is exactly what I need to dump just the data and not the table structure.

upvoted 0 times

...