Exercises

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?

Previous chapter: Summary

Jump to: