Oracle MySQL 5.7 Database Administrator - 1Z1-888 Exam Practice Test

Which MySQL utility copies the master instance to a slave instance on the same host?
Correct Answer: D
Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)
Correct Answer: D,E
Which are three facts about backups with mysqldump? (Choose three.)
Correct Answer: B,C,F
A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this? (Choose two.)
Correct Answer: B,E
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?
Correct Answer: B
Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)
Correct Answer: A,E
Explanation: (Only visible to PassTestking members)
Which two methods accurately monitor the size of your total database size over time? (Choose two.)
Correct Answer: C,F
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)
Correct Answer: A,D
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?
Correct Answer: D
This output is from a SHOW SLAVE STATUS:

What would cause the SQL_Delay variable to have a value of 360?
Correct Answer: D