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 network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• B.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.
• C.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.
• D.The mysql service has already been started on the same port.
• E.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.

Comment: *

Name: *

Email: *

Verification: *

This output is from a SHOW SLAVE STATUS:

What would cause the SQL_Delay variable to have a value of 360?

• A.The master has performed a large transaction, which will take 360 seconds to complete on the slave.
• B.The network latency between the master and the slave is 360 milliseconds.
• C.The slave will need an estimated 360 seconds to update the remaining contents from the relay log.
• D.The slave was configured for delayed replication with a delay of six minutes.

Comment: *

Name: *

Email: *

Verification: *

The /myfolder/my.cnf file has option set:
[mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?

• A.MySQL fails to start due to conflicting options on the command line.
• B.MySQL starts and Binary Logging is enabled.
• C.MySQL starts but Binary Logging is disabled.
• D.MySQL fails to start due to the conflicting options in the configuration files.

Comment: *

Name: *

Email: *

Verification: *

Which statement best describes the purpose of the InnoDB buffer pool?

• A.It is amount of buffers available during a transaction.
• B.It caches only the indexes for InnoDB tables.
• C.It caches data and indexes for InnoDB tables.
• D.It holds changes made during a transaction before they are written to the log.
• E.It is a pool of memory for SQL query sort operations from within the InnoDB engine.

Comment: *

Name: *

Email: *

Verification: *

You are investigating the performance of the server and see this information:
* events_waits_summary_global_by_event_name in the Performance Schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events.
* The Table_open_cache_overflows status variable is 0.
Which action should be taken to remove the performance bottleneck described here?

• A.Increase the value of table_definition_cache.
• B.Decrease the value of table_open_cache.
• C.Decrease the value of table_definition_cache.
• D.Increase the value of table_open_cache.
• E.Decrease the value of table_open_cache instances.
• F.Increase the value of table_open_cache_instances.

Comment: *

Name: *

Email: *

Verification: *