Oracle Exam 1Z0-888 Topic 7 Question 88 Discussion

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

Question #: 88
Topic #: 7

[All 1Z0-888 Questions]

You want to dump only data from the userdata table.

Which mysqldump command argument is required to accomplish this?

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

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

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

D- -table=userdata in order to dump only the data from the userdata table

Show Suggested Answer

Suggested Answer: B

by Olive at Apr 14, 2024, 03:12 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Sue

8 days ago

You know, I'm not sure any of these options are quite right. Wouldn't the --single-transaction argument be the way to go to get a consistent snapshot of the data?

upvoted 0 times

...

Jacklyn

10 days ago

Ooh, good catch! I was leaning towards the --data-only option, but --table=userdata might be even better. That way we don't have to worry about any other tables getting dumped.

upvoted 0 times

...

Marjory

11 days ago

Hey, what if we try to use the --table=userdata argument? That seems like it would be the most direct way to target just the userdata table.

upvoted 0 times

...

Veronika

12 days ago

Hmm, let me think this through. I'm pretty sure the --data-only option is the way to go here. That should just dump the data without the table structure, right?

upvoted 0 times

...

Lang

14 days ago

Yeah, I agree. This seems like a sneaky question. I wonder if they're trying to trip us up with all these different options.

upvoted 0 times

...

Solange

16 days ago

Woah, this question is a tricky one! I've used mysqldump before, but I'm not entirely sure which argument is the right one for dumping only the data from the userdata table.

upvoted 0 times

...