Which of the following best describes what mysqldumpslow does and how to use it? (Choose two)

• A. Shell> mysqldumpslow log_name
• B. Shell> mysqldumpslow < log_name
• C. It shows a summary of the slow log contents.
• D. It dumps the contents of the slow log into a readable format.

You have two databases, db1 and db2 and you have a table test in both of the databases. Your current default database is db1. Which of the following tables will be affected by the following command?
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON test TO 'joe'@'%' IDENTIFIED BY
'sakila'

• A. Db1.test
• B. The statement will return an error, because no database was specified.
• C. Both db1.test and db2.test
• D. Db2.test

Given the following MyISAM table structure:
mysql> desc city;
+-------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------+------+-----+---------+----------------+
| ID | int(11) | | PRI | NULL | auto_increment |
| Name | char(35) | | | | |
| CountryCode | char(3) | | | | |
| District | char(20) | | | | |
| Population | int(11) | | MUL | 0 | |
+-------------+----------+------+-----+---------+----------------+
And the following SQL statement: SELECT Population FROM city WHERE Population = 10000
ORDER BY Population LIMIT 5; which of the following statements best describes how MySQL
optimizer executes the query?

• A. The optimizer will never read data from disk, since MySQL caches both data and index in the key buffer.
• B. The optimizer uses the index on the Population column to search, filter and sort the Population column, then returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only, because the index contains just integer values that form a leftmost prefix for the key.
• C. The optimizer uses the index on the Population column to search, filter and sort the Population column, and returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only because only those columns where specified in the SELECT statement.
• D. The optimizer uses the index on the Population column to search and filter the WHERE clause. A temporary table is used to perform a filesort on the results, and then only 5 records are returned to the client.
• E. The optimizer uses the primary key column ID to read the index values, then uses the index on Population to filter the results. The optimizer will always choose to use a unique index first, then use a secondary index if available.

What is the effect of using WITH GRANT OPTION when executing the following statement?
GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com' IDENTIFIED BY 'Sakila' WITH GRANT OPTION

• A. The account 'joe'@'example.com' becomes an administrator account
• B. The account 'joe'@'example.com' may grant any type of privilege on tables in the world database to other users
• C. Nothing; WITH GRANT OPTION is not a valid clause in GRANT commands.
• D. The account 'joe'@'example.com' may grant SELECT, UPDATE and DELETE privileges on tables in the world database to other users

As an administrator, you attempt to create the account 'joe'@'example.com' with the following statement: GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com' Which of the following best describe the effects of issuing this statement?

• A. There is not enough information provided to determine the outcome of executing that statement.
• B. Since no password is specified, the account is created with an empty password that must be changed by the user on first login
• C. Depending on active SQL modes, you may be prevented from creating the account because no password is specified. Otherwise, an account with no password is created.
• D. The account is not created, as you must always specify a password for new users
• E. An account with no password is created, regardless of SQL modes. The password will not need to be set at a later time.