Examine the mysqldumpslow output:

Which two options could explain the slow query?

• A. A table lock is causing delays.
• B. A full table scan is being used.
• C. There are 108 queries still being executed.
• D. No index has been defined on the filtered column.
• E. There is network congestion between client and server.

Consider the key buffer in a MySQL server. Which two statements are true about this feature?

• A. It is a global buffer.
• B. It is set on a per-connection basis.
• C. It caches index blocks for MyISAM tables only.
• D. It caches index blocks for InnoDB tables only.
• E. It caches index blocks for all storage engine tables.

After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

• A. The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.
• B. The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.
• C. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• D. You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port
  80, which is in use by the built-in web server.
• E. The mysql service has already been started on the same port.

There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults. A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?

• A. --backup-instance=/var/lib/mysql/instance2
• B. --copy-back-from-log
• C. --instance=/var/lib/mysql/instance2
• D. --defaults-file=/etc/mysql/instance2.cnf
• E. --restore=2

To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

• A. Provide users access to the server's private key.
• B. Restart the server with the --require-x509 option.
• C. Set the X509 option in the [client] section of the MySQL server's configuration file.
• D. Distribute client digital certificates to the client computers being used to log in by the user accounts.
• E. Install the X509 plug-in on the server.