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?