Chapter 4 Review Questions

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

1. Which mysqld option gives anyone with access to the server unrestricted access to all databases?
   1. --allow-suspicious-udfs
   2. --safe-user-create
   3. --skip-grant-tables
   4. --skip-name-resolve
   5. --skip-show-database

2. Which is not a privilege needed for MySQL system administration?
   1. CREATE USER
   2. CREATE VIEW
   3. PROCESS
   4. SHUTDOWN
   5. SUPER

3. Which statement is false regarding privileges?
   1. The ALTER privilege may be used to subvert the privilege system by renaming tables.
   2. The GRANT privilege enables users to give their privileges to other users.
   3. The SHARE privilege enables users to share their privileges with other users.
   4. The SHUTDOWN privilege can be abused to deny service to other users entirely by terminating the server.
   5. The SUPER privilege can be used to terminate other clients or change how the server operates.

4. Which statement is true?
   1. MySQL password encryption is the same as that implemented by the SQL function ENCRYPT().
   2. MySQL passwords can be up to 16 characters long.
   3. MySQL usernames can be up to 16 characters long.
   4. The REMOVE USER statement automatically closes all open user sessions.
   5. The REMOVE USER statement removes one or more MySQL accounts.

---

---

© 2007 John Michael Pierobon

Notes