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