Question 1
Which two methods accurately monitor the size of your total database size over time? (Choose two.)
Question 2
A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a 'SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

You execute a 'SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?
Question 3
Consider the table people with this definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)
Question 4
This output is from a SHOW SLAVE STATUS:

What would cause the SQL_Delayvariable to have a value of 360?

What would cause the SQL_Delayvariable to have a value of 360?
Question 5
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.)