Oracle Exam 1Z0-915-1 Topic 7 Question 20 Discussion

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

Question #: 20
Topic #: 7

[All 1Z0-915-1 Questions]

You want to import data into a DB system with MySQL Shell util.loadDump().

Which option can speed up the load?

AupdateGtidSet: off

BshowMetadata: false

CskipBinlog: true

DdeferTableIndexes: all

Show Suggested Answer

Suggested Answer: B, C, D

by Eve at Mar 08, 2025, 06:49 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

3 days ago

Hmm, I'm not sure about that. Wouldn't that make it harder to keep track of the changes later on?

upvoted 0 times

...

16 days ago

I think option C is the way to go. Skipping the binary log should speed things up, right?

upvoted 0 times

...

16 days ago

I would go with option D) deferTableIndexes: all, as deferring table indexes can also improve the load performance.

upvoted 0 times

...

18 days ago

I agree with Mose, skipping the binlog can definitely help in speeding up the load process.

upvoted 0 times

...

21 days ago

I think option C) skipBinlog: true can speed up the load.

upvoted 0 times

...