1Z0-888 Exam Question 106
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 107
You created a backup of the worlddatabase with this command:
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql? (Choose two.)
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql? (Choose two.)
1Z0-888 Exam Question 108
You are remotely logged in to MySQL as the user "backup".
The account has temporarily been granted full privileges WITH GRANTto perform the actions required.
You want to change the password for the locally existing "backup" user.
Select the three commands which will perform the required action. (Choose three.)
The account has temporarily been granted full privileges WITH GRANTto perform the actions required.
You want to change the password for the locally existing "backup" user.
Select the three commands which will perform the required action. (Choose three.)
1Z0-888 Exam Question 109
Consider:

Which statement best describes the meaning of the values in the ref columns?

Which statement best describes the meaning of the values in the ref columns?
1Z0-888 Exam Question 110
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations. Which two other steps can help avoid data loss in a major catastrophe?