1Z0-883 · Question #34
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…
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.