Chapter 7 Review Questions

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

  1. Which is not a type of storage engine?
    1. ARCHIVE
    2. BLACKHOLE
    3. CSV
    4. DATA
    5. EXAMPLE

  2. Which statment is true?
    1. MyISAM and BDB storage engines provide transaction-safe tables.
    2. The FEDERATED storage engine allows a collection of identical MyISAM tables to be handled as a single table.
    3. The FEDERATED storage engine is the default storage engine.
    4. The MEMORY storage engine provides in-memory tables.
    5. The MERGE storage engine allows a collection of identical InnoDB tables to be handled as a single table.

  3. Which statement is false regarding InnoDB?
    1. InnoDB does locking on the row level and also provides an Oracle-style consistent non-locking read in SELECT statements.
    2. InnoDB has been designed for maximum performance when processing large data volumes.
    3. InnoDB provides MySQL with a transaction-safe storage engine that has commit, rollback, and crash recovery capabilities.
    4. InnoDB supports FOREIGN KEY constraints.
    5. One cannot mix InnoDB tables with tables from other MySQL storage engines.

  4. What is the name of the file flush technique that InnoDB uses that writes to a contiguous tablespace area?
    1. Doublebuffer
    2. Doubleread
    3. Doublewrite
    4. File buffering
    5. File write
[OUTLINE] [PREVIOUS] [NEXT PAGE] [CHAPTER 7]

© 2007 John Michael Pierobon

Notes