Question 66

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?
  • Question 67

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

    Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space. What will happen when this occurs?
  • Question 69

    You are investigating the performance of a query which selects data from an InnoDB table.
    Consider this Performance Schema diagnostics output for the query:

    Which statement is true about the output?
  • Question 70

    Exhibit:

    What does the possible_keys column in this output denote?