Assuming that the account 'joe'@'%' does not already exist on the server, executing the statement mysql> CREATE USER 'joe'@'%' IDENTIFIED BY 'sakila'

will have the following consequences:

A. The account 'joe'@'%' is created on the server. However, clients cannot connect using this account until further privileges have been assigned to the account.

B. The account 'joe'@'%' is created on the server. Clients may connect to the server using this account, but will not be able to access any databases, tables or stored routines

C. The account 'joe'@'%' is created on the server. Clients may connect to the server using this account and execute stored routines, but will not be able to access any databases or tables

D. Nothing; there is no such command as CREATE USER

Consider the following:

mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA'\G *************************** 1. row

***************************

id: 1

select_type: SIMPLE

table: City type: ALL

possible_keys: NULL

key: NULL

key_len: NULL

ref: NULL

rows: 4079

Extra: Using where

What does the possible_keys column in this output denote?

A. Whether there are any indexes on the table(s) you are querying.

B. If there are any indexes you may be able to use.

C. Whether you are using any indexes in your query.

D. If it is possible for you to include any indexes in your query.

Consider the following:

mysql> DESC customers;

+--------+------------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+--------+------------------+------+-----+---------+----------------+

| id | int(11) unsigned | NO | PRI | NULL | auto_increment |

| name_1 | char(20) | YES | MUL | NULL | |

| name_2 | varchar(20) | YES | | NULL | |

| name_3 | varchar(20) | YES | | NULL | |

| email | varchar(50) | YES | | NULL | |

+--------+------------------+------+-----+---------+----------------+

mysql> EXPLAIN SELECT * FROM customers WHERE name_1 = 'Johnny'\G

*************************** 1. row ***************************

id: 1

select_type: SIMPLE

table: customers type:

ref

possible_keys: i_name_1_01,i_name_1_02

key: i_name_1_01

key_len: 21

ref: const

rows: 1

Extra: Using where

What can be assumed by looking at the key_len column?

A. No indexes are being used.

B. The full index is being used.

C. The partial index is being used.

D. The longest index is 21 characters long.

Which of the following best describe the general steps involved in normalization?

A. Change the character set of the tables to normalize.

B. Remove repeating groups within rows.

C. Remove duplicate data within columns.

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

A. Table opening time.

B. Size limits of files.

C. Time to recover from a crash.

D. The number of users MySQL can handle.

E. The type of storage engines that can be used.