MySQL 5.7 Database Administrator: 1Z0-888

Which are three facts about backups with mysqldump? (Choose three.)

A. will lock all storage engines for duration of backup

B. can back up a remote database server

C. allow a consistent backup to be taken

D. are able to back up specific items within a database

E. create automatically compressed backups

F. are always faster to restore than binary backups

After rebooting the host, you attempt to start the mysqld service. You get the following error:

Can't start the server: Bind on TCP/IP port: Address already in use

What is the most likely cause of this error?

A. The mysqld service has already been started on the same port.

B. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.

C. You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port 80, which is in use by the built-in web server.

D. The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.

E. The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.

A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance? (Choose two.)

A. a backup created with mysqldump --all-databases

B. a backup created using FLUSH TABLES ... FOR EXPORT

C. an up-to-date replication slave

D. a file system-level snapshot

E. a file system copy created while MySQL was shut down.