Question 91

Consider these global status variables:

Which two conclusions can be made from the output?
  • Question 92

    To query two system variables, you execute this statement and get the results shown:

    When you execute the following two statements, only the first one succeeds:
    SET @@autocommit=0;
    SET @@max_connections=200;
    Why does the second statement fail?
  • Question 93

    old_alter_table is disabled as shown.
    mysql> SELECT @@old_alter_table;

    Consider this statement on a RANGE-partitioned table:
    mysql> ALTER TABLE orders DROP PARTITION p1, p3;
    What is the outcome of executing this statement?
  • Question 94

    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 95

    After rebooting the host, you attempt to start the mysqld service. You get the following error:
    Can't start the server: Bind on TCP/IP port: Address already in use
    What is the most likely cause of this error?