Question 71

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?
  • Question 72

    Consider the key buffer in a MySQL server. Which two statements are true about this feature?
  • Question 73

    Consider:

    Which statement best describes the meaning of the value for the key_lencolumn?
  • Question 74

    You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

    What would you run to fix the issue?
  • Question 75

    You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?