Question 26

Exhibit:

What does the possible_keys column in this output denote?
  • Question 27

    One of your colleagues is trying to make a change using the mysqlcommand-line client for his or her application session.
    The colleague instant messages you this command:
    mysql> SET SESSION max_connections = 200;
    Why does the command fail?
  • Question 28

    You have a server that has very limited memory but has a very large table.
    You will use mysqldumpto back up this table.
    Which option will ensure mysqldumpwill process a row at a time instead of buffering a set of rows?
  • Question 29

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

    What are three methods to reduce MySQL server exposure to remote connections?
    (Choose three.)