Chapter 3 Review Questions

Let us see how much you have learned in this chapter by going over these review questions.

  1. What are the two kinds of system variables that mysqld maintains?
    1. Conditional variables and fixed variables.
    2. Environment variables and global variables.
    3. Environment variables and system variables.
    4. Global variables and session variables.
    5. Startup variables and system variables.

  2. Executing which program is the recommended way to start a mysqld server?
    1. mysqld_install
    2. mysqld_multi
    3. mysqld_safe
    4. mysqld_start
    5. mysqlmanager

  3. Which mode changes syntax and behavior to conform more closely to standard SQL?
    1. ANSI
    2. LOCAL
    3. STANDARD
    4. STRICT_TRANS_TABLES
    5. TRADITIONAL

  4. During the shutdown process, which step is performed last?
    1. Storage engines are shut down or closed.
    2. The server creates a shutdown thread if necessary.
    3. The server receives a SIGTERM signal.
    4. The server stops accepting new connections.
    5. The server terminates current activity.
[OUTLINE] [PREVIOUS] [NEXT PAGE] [CHAPTER 3]

© 2007 John Michael Pierobon

Notes