Suppose you are adding rows to a MyISAM table and the --datadirlocation runs out of disk space.
What will happen when this occurs?

Why should you be selective when granting the PROCESS privilege to an account?

Given these table definitions and the explain plan:

Which ALTER TABLE statement will improve the performance of the query?

Which three allocate memory per thread in MySQL?

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysqlclient to connect to the server and send clear text passwords?
(Choose two.)