Oracle
1Z0-883 · Question #34
1Z0-883 Question #34: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #34. The question stem and answer options stay visible for context.
Question
You have table
apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell> mysqldump u root h server no-data apps userdata | mysql u root p apps Shell> mysql u root p h server e ALTER TABLE `apps','userdata' ENGINE=InnoDB;' Shell> mysqldump u root p h server no-create-info order-by-primary apps userdata | mysql u root p apps What effect does the ?order-by-primary argument have on the mysqldump command?Options
- AIt exports tables with the most indexes first to assist with import speeds.
- BIt ensures that unique indexes have no conflicts when the data is dumped.
- CIt orders by primary key to assist in speeding up importing to InnoDB tables.
- DIt must be specified so index data is dumped correctly when on-create-info is used.
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.