2.5 Exercises
| Question 1: | Which of the following MySQL 4.x distributions include support for InnoDB tables? Under which license are those distributions shipped?
| | Question 2: | Is the following statement true or false?
All of the MySQL client programs and utilities communicate with the MySQL server. | | Question 3: | Is the following statement true or false?
When running a MySQL server under Windows, client programs accessing that server must also run under Windows. | | Question 4: | Is the following statement true or false?
A command-line program commonly used to communicate with the server is called mysqld. | | Question 5: | Is the following statement true or false?
MySQL client programs and utilities can only be obtained from the binary distributions, as the MySQL source distributions contain only the server. |
Answers to Exercises | | | Answer 1: | Except for the commercially licensed Classic distribution, all distributions include support for InnoDB tables. Like Classic, the Pro distribution is shipped under a commercial license, whereas Standard and Max are available under the GNU General Public License. | | | | Answer 2: | False. There are MySQL utilities that don't communicate with the server, but work directly on MyISAM tables. Examples include myisamchk and myisampack. | | | | Answer 3: | False. MySQL can be used in heterogeneous environments. For example, a server running on a Unix host can be accessed by clients running on Windows machines. | | | | Answer 4: | False. The most commonly used command-line program is called mysql, not mysqld. The latter is the MySQL server. | | | | Answer 5: | False. MySQL client programs, utilities, and the server all can be obtained both in source and in binary form. |
|
