欢迎来到在线考试题库网 在线考试题库官网
logo
全部科目 > Oracle认证考试 > 1z0-883

单项选择题

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

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题