Hudzilla.org - the homepage of Paul Hudson

9.21 Exercises

This is NOT the latest copy of this book; click here for the latest version.

Which of the following data types are incorrect in MySQL?
- a) CHAR(20)
- b) VARCHAR(300)
- c) TEXT
- d) LONGINT
- e) None of the above
Suggest the ideal data type for the following fields:
- a) First name
- b) Age
- c) Height
- d) Life story
When are LOW_PRIORITY-marked writes executed?
- a) After ten seconds
- b) After the next read
- c) When no more reads remain
- d) When FLUSH WRITES is called
Temporary tables are automatically deleted when your scripts ends: true or false?
Which of the following statements are true about indexes:
- a) They usually speed up queries
- b) They take up extra disk space
- c) They slow table writes down
- d) None of the above
- e) All of the above except d)
You can emulate subselects using multiple individual queries: true or false?
Unbuffered queries allow you to start reading in the result of a query before the query has been finished: true or false?
What is SQLite's key advantage over MySQL and other DBMSs?
Using PEAR::DB is usually as fast if not faster than standard database calls: true or false?

<< 9.20 Summary		9.22 Further reading >>
Table of Contents

Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.

My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!

Be the first to add a comment to this chapter!

Add comment
Please note that by posting a comment here you are committing it to the public domain. This is important so that others can make use of your code themselves, and also so that I can incorporate helpful notes directly into the main text. Comments are limited to 2000 characters in length.

If you are reporting an error in the content, please tell me directly.