You have been granted SELECT, INSERT and DELETE privileges on the table city in the world database. You log in, and exercise all your privileges without any problems.

While you are still connected and doing work, the administrator removes your DELETE privileges and informs you by mail that you can no longer delete from table city.

Being skeptical, you decided to test your privileges and realize that you still have them all. What is are the most likely causes of this?

A. The administrator forgot to revoke your UPDATE privilege

B. The administrator forgot to revoke your SELECT privilege

C. The administrator removed the DELETE privilege by performing an UPDATE directly on the mysql.table_priv table

D. The administrator did not execute FLUSH PRIVILEGES

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. The account is not created, as you must always specify a password for new users

B. 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.

C. An account with no password is created, regardless of SQL modes. The password will not need to be set at a later time.

D. Since no password is specified, the account is created with an empty password that must be changed by the user on first login

E. There is not enough information provided to determine the outcome of executing that statement.

Consider the following two partial outputs of the SHOW VARIABLES command on a master and slave

server:

Master:

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

| Variable_name | Value |

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

| connect_timeout | 5 |

| log_bin | ON |

| max_connections | 100 |

| shared_memory_base_name | MYSQL |

| server_id | 2 |

| tmp_table_size | 5242880 |

| version | 5.0.13-rc-nt |

Slave:

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

| Variable_name | Value |

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

| connect_timeout | 5 |

| log_bin | ON |

| max_connections | 10 | | shared_memory_base_name | MYSQL | | server_id | 2 |

| tmp_table_size | 4266336 |

| version | 5.0.16-rc-nt |

There is apparently a problem with the slave replicating from the master. Which of the following best

describes the most likely problem?

A. The server_id is not unique.

B. The version of the slave is newer than the version of the master.

C. The connect_timeout variable needs to be increased.

D. The max_connections variable needs to be increased.

The user 'joe' connecting from the host example.com has full access to all databases on the server:

mysql> SHOW GRANTS FOR 'joe'@'example.com';

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

| Grants for joe@example.com |

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

| GRANT ALL PRIVILEGES ON *.* TO 'joe'@'example.com' |

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

1 row in set (0.00 sec)

You need to restrict the user from accessing the mysql database. Will the following statement do this?

REVOKE ALL PRIVILEGES ON mysql.* FROM 'joe'@'example.com'

A. Yes

B. No

C. The answer cannot be determined from the information provided.

Which of the following statements are true regarding the slow query log?

A. The slow query log can be switched on with the log_slow_queries option.

B. The slow query log is always enabled.

C. The slow query log contains queries that don't utilize any index.

D. To have the slow query log contain queries that don't utilize any index, the log-queries-not- using-indexes option needs to be set.

E. The slow query log will contain queries that take more than 10 seconds.

F. The slow query log will contain queries that take more seconds than configured in the long_query_time option.

G. You can use the mysqldumpslow command line tool to summarize the content of the slow query log.

H. You can use the SHOW SLOW QUERIES statement to display all entries in the slow queries log.

Consider the following:

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

| id | PartName | Location |

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

| 1 | 40GB Hard Drive | Jacksonville |

| 2 | 1GB DDR | Atlanta |

| 3 | Keyboard | San Jose |

| 4 | Monitor | Harrisburg |

| 5 | USB Drive | Miami |

| 6 | DVD/R | Jacksonville |

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

Which of the following best describes why this table should be split into a part and location table?

A. Because it has redundant location values.

B. Because it has multiple repeating groups in each row.

C. This table should not be split as it is already in third normal form.

Which of the following best describes the purpose of the record buffer (as controlled through the read_buffer_size variable), and how it is set?

A. The record buffer is set per connection.

B. The record buffer is used for operations such as ORDER BY or GROUP BY.

C. The record buffer is global and is only set by restarting the server.

D. The record buffer is used to perform sequential table scans, reducing the number of reads from disk.

When should you enable the Query Cache?

A. A lot of repeating and identical SELECT queries are received by the server.

B. The underlying tables don't change very often.

C. The server machine has more than one CPU.

D. The server machine has more than one network interface.

Which of the following best describe some possible benefits of using RAID?

A. Better user-level security.

B. Data redundancy.

C. Read performance gains.

D. Write performance gains. E. Hot-swappable disk drives.

E. Better memory and processor utilization.

Which of the following are requirements for running more than one MySQL server on the same machine?

A. On Windows each server that runs as a service must have a different service name.

B. Each server must have its own log files.

C. Each server must share the same error log.

D. Each server must run on a different disk.

E. Each server must have its own network interfaces.

F. There must be more than one processor on the machine.

G. InnoDB tablespace files must be separate between servers.