Name:

Quiz 14

Regarding Reading 14.

1. SQLite infers the datatype of literal values. Given the literal '2', what would be the storage class used to represent that value?
2. What does the function typeof() do?
3. SQLite is considered a "Zero-configuration" database, and it's easy to get up and running quickly. However, you can certainly configure how SQLite operates via PRAGMA commands. Where does SQLite store its configuration?
4. What is the sqlite_master table?
5. One important aspect of analyzing database performance is understanding how a database carries out a query. How can you obtain this information with SQLite?