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 userda

题目

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 appsShell> 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 appsWhat 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


相似考题
更多“You have table ‘apps‘,‘userdata‘ on server that uses MyISAM storage engine.You want to tra ”相关问题
  • 第1题:

    —Where____you____lunch?

    —Athome.Therewasnoschoollunch

    A.did;have

    B.are;having

    C.will;have

    D.do;have


    正确答案:A

  • 第2题:

    Deploying the cisco unified computing system platform into the data center provides which two benefits?()

    A.it leverages low-speed interfaces

    B.only one configuration is used for all blades

    C.storage, computing and networking services are combined onto one blade

    D.it is A pra-as-you-go incremental deployment

    E.server replacement is as easy as replacing the physical blade


    参考答案:D, E

  • 第3题:

    以下属于调用摄像头硬件的权限的是:()

    A.<uses-permission android:name="android.permission.CAMERA"/>

    B.<uses-permission android:name="android.permission.MOUNT_UNMOUNT_FILESYSTEMS" />

    C.<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>

    D.<uses-permission android:name="android.permission.INTERNET"/>


    A

  • 第4题:

    关于myisamchk工具,以下描述正确的有哪些?()

    A.它能检查MyISAM表

    B.它能修复MyISAM表

    C.它能获取MyISAM表的信息

    D.它能优化MyISAM表


    参考答案:ABCD

  • 第5题:

    You look() What()you()?

    Atire;did;do

    Btiring;have;done

    Ctired;do;do

    Dtired;have;been doing


    D