Which three options are most likely to be changed for production form their default values? (Choose three.)
What is the order of tables shown in an EXPLAIN output?
A master-slave replication setup has the slave showing this error:On the master server, the binary logs show:What could explain this error?
A MySQL replication slave is set up as follows:Uses all InnoDB tables -Receives ROW-based binary logs -Has the read-only option -The replication slave has been found in an error state.You check the MySQL error log file and find these entries:What are two possible causes for this error to occur? (Choose two.)
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:The MySQL Server is restarted without error.What effect will the new configuration have on existing account?
You have just executed a manual backup by using this command: mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backupThe operation completed without error.What is the state of this backup and operation required before it is ready to be restored?
