Question 121

Which statement is true about tablespaces?
  • Question 122

    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?
  • Question 123

    A MySQL replication slave is set up as follows:
    * Uses all InnoDB tables
    * Receives ROW-based binary logs
    * Has the read-only option
    The replication slave has been found in an error state.
    You check the MySQL error log file and find these entries:

    What are two possible causes for this error to occur? (Choose two.)
  • Question 124

    You need to dump the data from the master server and import it into a new slave server.
    Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?
  • Question 125

    You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
    Which statement describes the activation of that access for the user?