首页 试题详情
多选题


Choose two.
You must export data from a set of tables in the world_x database. Examine this set of tables:
Tables (country, countryinfo, location)
Which two options will export data into one or more files?

Ashell> mysqldump world_x country countryinfo location > mydump.sql

Bmysql> SELECT * INTO OUTFILE ‘/output/country. txt‘ FROM world_x.country; mysql> SELECT * INTO OUTFILE ‘/output/countryinfo. txt‘ FROM world_x.countryinfo; mysql> SELECT * INTO OUTFILE ‘/output/location. txt‘ FROM world_x.location;

Cshell> mysqlexport world_x country countryinfo location > mydump.sql

Dmysql> CLONE LOCAL DATA DIRECTORY = ‘/var/lib/mysql/world_x/country‘ ; mysql> CLONE LOCAL DATA DIRECTORY = ‘/var/lib/mysql/world_x/countryinfo‘ ; mysql> CLONE LOCAL DATA DIRECTORY = ‘/var/lib/mysql/world_x/location‘ ;

Eshell> mysql --batch world_x.country world_x.countryinfo world_x.1ocation > mydump.sql

查看答案
正确答案：A （备注：此答案有误）

相似试题

  • 多选题

    Choose two.You must export data from a set of tables in the world_x database. Examine this set of tables:Tables (country, countryinfo, location)Which two options will export data into one or more files?

    答案解析

  • 多选题

    Choose two.A valid raw backup of the shop.customers MyISAM table was taken. You must restore the table. You begin with these steps:1Confirm that secure_file_priv= ‘/var/tmp ‘2mysql> DROP TABLE shop.customers;3shell> cp /backup/customers.MY* /var/1ib/mysql/shop/ Which two actions are required to complete the restore?

    答案解析

  • 多选题

    Choose two.You are using mysqlcheck for server maintenance. Which two statements are true?

    答案解析

  • 单选题

    You should choose a dentist in _____ the same way as you choose a physician, get the names of two or three dentists from friends and relatives and have a preliminary visit with each.

    答案解析

  • 多选题

    Choose three.You must run multiple instances of MySQL Server on a single host. Which three methods are supported?

    答案解析

热门题库