1Z1-888 Exam Question 86

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUSoutput:

You execute a 'SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVEcommand. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVEcommand to resolve the duplicate key error. Which statement should be used?
  • 1Z1-888 Exam Question 87

    An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user's shell setting.
    Which statement is true?
  • 1Z1-888 Exam Question 88

    Examine the mysqldumpslow output:

    Which two options could explain the slow query? (Choose two.)
  • 1Z1-888 Exam Question 89

    You are using GTIDSin replication. You need to skip a transaction with the GTIDof aaa-bbb-ccc-ddd- eee:3on a slave.
    Which procedure would you execute from a MySQL prompt?
  • 1Z1-888 Exam Question 90

    Which two statements are true about InnoDB auto-increment locking?