Question 34:

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 option will export data into one or more files?

A) mysql> 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';

B) mysql> SELECT * INTO OUTFILE '/output/contry.txt' FROM world_x.country;
mysql> SELECT * INTO OUTFILE '/output/contryinfo.txt' FROM world_x.countryinfo;
mysql> SELECT * INTO OUTFILE '/output/location.txt' FROM world_x.location;

C) shell> mysqlexport world_x country countryinfo location > mydump.sql

D) shell> mysql --bathch world_x.country world_x.countryinfo world_x.location > mydump.sql

E) shell> mysqldump world_x country countryinfo location > mydump.sql