You created a backup of the worlddatabase with this command:
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql? (Choose two.)

Which two statements are true about InnoDB auto-increment locking? (Choose two.)

Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer?

You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.
The requirements for the backup are:
* It must be possible to rebuild the instance using the backup.
* It must be verified.
* It must allow for a catastrophic hardware failure.
Which four steps must be included in the backup strategy? (Choose four.)

Which three tasks are handled by the optimizer?