1Z0-888 Exam Question 6

What two statements are true regarding FLUSH TABLES FOR EXPORT?
  • 1Z0-888 Exam Question 7

    You have just executed a manual backup by using this command:
    mysqlbackup -u root -p --socket=/tmp/my.sock --backup-dir=/my/backup/ backup The operation completed without error.
    What is the state of this backup and operation required before it is ready to be restored?
  • 1Z0-888 Exam Question 8

    Examine the mysqldumpslow output:

    Which two options could explain the slow query?
  • 1Z0-888 Exam Question 9

    How does the InnoDB storage engine handle deadlocks when they are detected?
  • 1Z0-888 Exam Question 10

    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;