Which of the following data types are incorrect in MySQL?
e) None of the above
Suggest the ideal data type for the following fields:
a) First name
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?
Want to learn PHP 7?
Hacking with PHP has been fully updated for PHP 7, and is now available as a downloadable PDF. Get over 1200 pages of hands-on PHP learning today!
If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!
Next chapter: Further reading >>
Previous chapter: Summary
Home: Table of Contents
Copyright ©2015 Paul Hudson. Follow me: @twostraws.