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?
  • 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.)
  • 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.)
  • 1Z0-888 Exam Question 109

    Consider:

    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?