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?

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?
Which statement is true?
1Z1-888 Exam Question 88
Examine the mysqldumpslow output:

Which two options could explain the slow query? (Choose two.)

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?
Which procedure would you execute from a MySQL prompt?
1Z1-888 Exam Question 90
Which two statements are true about InnoDB auto-increment locking?