Regarding Reading 11.
- What is the difference between a view and a table?
- 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';
- Identify six database events upon which SQLite triggers can be invoked. (eg, one is before insert).
- What is one easy way of recognizing whether or not a subquery is a correlated subquery?