Question 1

Although SQL is a language, you don't use it to write applications.

Question 1 options:

	True
	False

Question 3

The column that is designated as the primary key must hold a unique value for each row.

Question 3 options:

	True
	False

Question 4

All identity columns in a table must contain the same value.

Question 4 options:

	True
	False

Question 6

The SQL INSERT statement only inserts one row.

Question 6 options:

	True
	False

Question 8

An SQL aggregate function performs a calculation on a set of values from a database table and returns a single value.

Question 8 options:

	True
	False

Question 9

The Connection object's commit method saves any changes that have been made to the database.

Question 9 options:

	True
	False

Question 19

Suppose an SQLite database has a table named Customers. The Customers table has a REAL column named Purchases. Which SQL statement returns the sum of the Purchases column?

Question 19 options:

A)	SELECT Customers.SUM(Purchases)

B)	SELECT COUNT(Purchases) FROM Customers

C)	SELECT TOTAL(Customers) FROM Purchases

D)	SELECT SUM(Purchases) FROM Customers