Chapter 1 Review Questions

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

  1. Which configure option would build the embedded MySQL library?
    1. configure --help
    2. configure --server
    3. configure --with-embedded-server
    4. configure --with-mysqld-ldflags=embedded-library
    5. configure --with-server

  2. What should one try if virtual memory is exhausted when compiling MySQL?
    1. ./configure --server
    2. ./configure --with-embedded-server
    3. ./configure --with-low-memory
    4. ./configure --with-mysqld-ldflags=virtual-memory
    5. ./configure --with-server

  3. Which statement is false?
    1. MySQL is a relational database management system.
    2. MySQL is developed, distributed, and supported by IBM, the inventors of SQL.
    3. MySQL is fast, reliable, and easy to use.
    4. MySQL is multithreaded and multi-user.
    5. MySQL software is Open Source.

  4. Which statement is false?
    1. Grant tables define the initial MySQL user accounts and their access privileges.
    2. To encrypt the password use the ENCRYPT() function.
    3. Use the mysqladmin command line client program to assign passwords to the root accounts.
    4. Use the SET PASSWORD statement to assign passwords to the root accounts.
    5. Use the UPDATE statement to assign passwords to the root accounts.
[OUTLINE] [PREVIOUS] [NEXT PAGE] [CHAPTER 1]

© 2007 John Michael Pierobon

Notes