Question 96
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?
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?
Question 97
After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output? (Choose two.)

What are the two most likely reasons for the slowness given this output? (Choose two.)
Question 98
Which two methods will provide the total number of partitions on a table? (Choose two.)
Question 99
The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO 'webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO 'webadmin'@'%';
A user successfully connects to the database as webadminand created a stored procedure named get_reports.The next day, the user logs in again as webadminand wants to delete the stored procedure named get_reports,and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?
GRANT CREATE ROUTING ON sales.* TO 'webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO 'webadmin'@'%';
A user successfully connects to the database as webadminand created a stored procedure named get_reports.The next day, the user logs in again as webadminand wants to delete the stored procedure named get_reports,and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?
Question 100
The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.
Which two are true about the login path feature? (Choose two.)
Which two are true about the login path feature? (Choose two.)
