Formatting text in a word-processing document

DDL, used for defining database structures

DOM, used for manipulating web page elements

Copies data from an existing table into a new table

Permanently deletes all rows from a table

Changes the data type of an existing column

An error, because arithmetic cannot appear in a SELECT list

A calculated column named Total holding Price multiplied by Quantity for each row

A new table named Total, stored permanently in the database

No, WHERE can only reference columns that are also selected

Yes, WHERE can reference any column in the table being queried

Neither, they are always evaluated strictly left to right

INSERT INTO Customers (Name) VALUES ('Liam');

None, NULL is never permitted in a column

UPDATE Customers City = 'Oslo' WHERE CustomerID = 3;

UPDATE Customers SET City = 'Oslo' WHERE CustomerID = 3;

SET Customers City = 'Oslo' WHERE CustomerID = 3;

It is dropped along with the removed data

A list of CustomerID values to compare against

A single aggregate number, such as a total count

No, it only relabels the column in the query's result set

Yes, but only until the database restarts

One condition covering all three tables at once

Two conditions, one for each additional table joined

No, UNION supports exactly two SELECT statements

Yes, any number of SELECT statements can be combined

A single row summarizing the entire table

Rows with NULL in that column are excluded from the results

SELECT CustomerID, COUNT(*) FROM Orders GROUP BY CustomerID HAVING COUNT(*) > 5;

SELECT CustomerID, COUNT(*) FROM Orders WHERE COUNT(*) > 5 GROUP BY CustomerID;

SELECT CustomerID, COUNT(*) FROM Orders GROUP BY CustomerID WHERE COUNT(*) > 5;

To explain or document parts of the query for other readers

To force the database engine to cache the results

No, a table may have only one UNIQUE constraint

Yes, a table can have multiple UNIQUE constraints

Only if those columns are also declared PRIMARY KEY

A SELECT statement checking a submitted username and password

SQL Quiz