多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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?()

  • A、It exports tables with the most indexes first to assist with import speeds
  • B、It ensures that unique indexes have no conflicts when the data is dumped
  • C、It orders by primary key to assist in speeding up importing to InnoDB tables
  • D、It must be specified so index data is dumped correctly when  –on-create-info is used
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题