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?
  • 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.)
  • Question 4

    This output is from a SHOW SLAVE STATUS:

    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.)