1Z1-888 Exam Question 116
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?
1Z1-888 Exam Question 117
What two statements are true regarding FLUSH TABLES FOR EXPORT? (Choose two.)
1Z1-888 Exam Question 118
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUSindicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?
STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
The SHOW SLAVE STATUSindicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?
STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
1Z1-888 Exam Question 119
Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?
1Z1-888 Exam Question 120
Which two are considered good security practices when using passwords? (Choose two.)