1Z1-888 Exam Question 111
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-typeis set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)
1Z1-888 Exam Question 112
You want to create a temporary table named OLD_INVENTORYin the OLD_INVENTORYdatabase on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave?
Which two changes would ensure that the temporary table does not propagate to the slave?
1Z1-888 Exam Question 113
What two statements are true regarding FLUSH TABLES FOR EXPORT?
1Z1-888 Exam Question 114
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?
1Z1-888 Exam Question 115
Consider the index information for the dept_emp table in the employee's schema:

Which two conclusions can be made based on the output of the query? (Choose two.)

Which two conclusions can be made based on the output of the query? (Choose two.)