Question 1

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)
  • Question 2

    Consider that local disk files are accessible via MySQL with commands such as:
    mysql> LOAD DATA LOCAL INFILE '/etc/passwd' INTO TABLE mypasswords;
    What change could be made to stop any breach via this insecurity?
  • Question 3

    There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
    The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults.
    A restore of the second instance is attempted from the mysqlbackup archive using this command:
    mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
    Upon starting the second MySQL instance, you notice that the data does not match the expected backup. Which command-line option is required to successfully update the second instance?
  • Question 4

    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 5

    The Performance Schema includes these tables related to status variables:

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