In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data.

You then TRUNCATE this table to empty it.

Mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;

mysql> TRUNCATE t1;

Which two methods will restore data to the t1 table?

Consider the query:

Mysql> SET @run = 15;

Mysql> EXPLAIN SELECT objective, stage, COUNT (stage)

FROM iteminformation

WHERE run=@run AND objective=’7.1’

GROUP BY objective,stage

ORDER BY stage;

The iteminformation table has the following indexes;

Mysql> SHOW INDEXES FROM iteminformation:

This query is run several times in an application with different values in the WHERE clause in a growing data set.

What is the primary improvement that can be made for this scenario?

You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database.

You test whether the import was successful by using the following commands:

Mysql> select user, host, password from mysql.user;

9 rows in set (0.00 sec)

Mysql> show grants for ‘admin’@’%’;

ERROR 1141 (42000): There is no such grant defined for user ‘admin’ on host ‘%’

Which command will fix this issue?