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 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.
• 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 will never read data from disk, since MySQL caches both data and index in the key buffer.
• 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.

Which of the following best describes the relationship between MAX_ROWS, AVG_ROW_LENGTH and the max table size?

• A. MAX_ROWS + AVG_ROW_LENGTH tells MySQL to not let the table grow past that size.
• B. Specifying MAX_ROWS and AVG_ROW_LENGTH will prevent MySQL from growing the table beyond that limit.
• C. Specifying MAX_ROWS and AVG_ROW_LENGTH doesn't prevent MySQL from growing the table beyond that limit.
• D. MAX_ROWS * AVG_ROW_LENGTH tells MySQL how large you expect the table to grow to.

The type of file system you chose may affect MySQL use and/or performance with regard to... (Choose three)

• A. The type of storage engines that can be used.
• B. Size limits of files.
• C. Time to recover from a crash.
• D. The number of users MySQL can handle.
• E. Table opening time.

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. Nothing; WITH GRANT OPTION is not a valid clause in GRANT commands.
• C. The account 'joe'@'example.com' may grant SELECT, UPDATE and DELETE privileges on tables in the world database to other users
• D. The account 'joe'@'example.com' may grant any type of privilege on tables in the world database to other users