Oracle Exam 1Z0-888 Topic 9 Question 86 Discussion

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

Question #: 86
Topic #: 9

You need to dump the data from the master server and import it into a new slave server.

Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?

Ainclude-log-file

Bmaster-binlog

Cinclude-master-info

Dmaster-data

Show Suggested Answer

Suggested Answer: D

by Edna at Mar 05, 2024, 10:37 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

1 years ago

Master-data only includes the table structures and data, but we also need the master server's binary log information.

upvoted 0 times

...

1 years ago

I'm not sure, but wouldn't D) master-data be the right choice for this situation?

upvoted 0 times

...

1 years ago

I agree with Laura, including the master server's information is important for consistency.

upvoted 0 times

...

1 years ago

I think the correct option is C) include-master-info.

upvoted 0 times

...