Name:

Quiz 11

Regarding Reading 11.

1. What is the difference between a view and a table?
2. If a database has the following index defined, CREATE INDEX foo ON cars(name), will the following query perform any faster? Explain why or why not.
   SELECT * FROM cars WHERE name = 'Slugbug';
3. Identify six database events upon which SQLite triggers can be invoked. (eg, one is before insert).
4. What is one easy way of recognizing whether or not a subquery is a correlated subquery?