1Z0-888 Exam Question 36

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?
  • 1Z0-888 Exam Question 37

    You have just executed a manual backup by using this command:
    mysqlbackup -u root -p --socket=/tmp/my.sock --backup-dir=/my/backup/ backup The operation completed without error.
    What is the state of this backup and operation required before it is ready to be restored?
  • 1Z0-888 Exam Question 38

    Which three allocate memory per thread in MySQL?
  • 1Z0-888 Exam Question 39

    You want to immediately stop access to a database server for remote user 'mike'@'client.example.com'. This user is currently not connected to the server.
    Which two actions can you take to stop any access from the user?
  • 1Z0-888 Exam Question 40

    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?