1Z0-888 Exam Question 81
Which statement best describes the purpose of the InnoDB buffer pool?
1Z0-888 Exam Question 82
You are asked to examine user accounts and find:

Which two statements will best secure this environment? (Choose two.)

Which two statements will best secure this environment? (Choose two.)
1Z0-888 Exam Question 83
SQL injection is a common security threat.
Which two methods would help protect against this risk? (Choose two.)
Which two methods would help protect against this risk? (Choose two.)
1Z0-888 Exam Question 84
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?

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?
1Z0-888 Exam Question 85
You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.
You start to restore your backup with this command;
shell> mysql -u root -p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?
You start to restore your backup with this command;
shell> mysql -u root -p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?
