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?

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?
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?
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?
mysql> LOAD DATA LOCAL INFILE '/etc/passwd' INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?