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?
  • 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.)
  • 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?
  • 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.)