Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 1

Should never be done for any users. ✘ Should always be done for all users. ✘ Should only be done on administrator accounts. ✘ Should be done for anyone needing to create views ✔

They can make use of the VALIDATE DEFINER setting. ✘ They can not be used to check for constraints or legality of data. ✘ They can check and only perform an action if the incoming values match a specified value. ✘

They change with every upgrade. ✘ They are often changed. ✘ They remain the same for backwards compatibility. ✘

The number of times per hour that an account is allowed to connect to the server The number of queries per hour an account is allowed to issue The number of updates per hour an account is allowed to issue The maximum number of simultaneous connections an account can have Resource limits can only be specified globally, not per-account

Joins are more prone to mistakes. ✘ Using EXPLAIN before executing the query helps the server prepare the statements used. ✘ Joins have the potential to cause more server processing if not defined correctly. ✘

On a server with multiple network interfaces, you can have mysqld accept connections only on the given interface. ✘ Mysqld will only accept connections from the given address. ✘ Mysqld will turn off networking and will only accept local connections ✘ Mysqld won't accept any connections at all. ✔

Because it allows a client to kill other client connections. Because it allows a client to shutdown the server. Because it allows changing of the server runtime configuration. Because it allows client accounts to takeover other client accounts.

No, it has to be done programmatically. ✘ Yes, by updating a system variable. ✘ Yes, there is a SQL mode that exists for that. ✘ No, division-by-zero is always converted regardless of any setting. ✔

host global database table column

Disable the mysql_access program ✘ Run the mysql_secure_installation script ✘ Nothing; by default the security level of a MySQL installation is very high ✘