Chapter 5 Review Questions

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

  1. Which statement clears or reloads various internal caches used by MySQL?
    1. CLEAR
    2. CLEAR CACHE
    3. FLUSH
    4. LOCK
    5. RELOAD

  2. What is the name of the utility gets information about database tables or checks, repairs, or optimizes them?
    1. myisamchk
    2. mysqladmin
    3. mysqlbinlog
    4. mysqldump
    5. mysqlhotcopy

  3. Which statement is false?
    1. InnoDB does not store table contents in database directories.
    2. mysqldump can be use for backup.
    3. mysqlhotcopy can be use for backup.
    4. mysqlhotcopy only works for MyISAM tables.
    5. mysqlhotcopy only works with InnoDB tables.

  4. Which statement is false?
    1. cron can be used to automate periodic table maintenance.
    2. MyISAM table maintenance can be done using SQL statements.
    3. OPTIMIZE TABLE does a table repair and a key analysis.
    4. OPTIMIZE TABLE sorts the index tree so key lookups are faster.
    5. The InnoDB storage engine lacks support for transactions and automatic crash recovery.
[OUTLINE] [PREVIOUS] [NEXT PAGE] [CHAPTER 5]

© 2007 John Michael Pierobon

Notes