Question 16

You have a MySQL instance with the following variables in the /etc/my.cnffile:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)
  • Question 17

    You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?
  • Question 18

    A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

    You execute a `SHOW CREATE TABLE mytable" on the slave:

    The table mytable on the slave contains:

    You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?
  • Question 19

    The Performance Schema includes these tables related to status variables:

    Which two facts are true about these tables? (Choose two.)
  • Question 20

    You enable binary logging on MySQL Server with the configuration:
    binlog-format=STATEMENT
    log-bin
    Which database updates are logged on the master server to the binary log by default?