Question 1 (3 points)

What is the wildcard character in the SELECT clause to show all columns?

	$ (dollar sign)
	% (percent sign)
	& (ampersand)
	* (asterisk)

Question 2 (3 points)

A column alias can be assigned with the keyword AS to choose the display name in the header; without an alias, the default display name for a column value is the column name. What is the default display name for a calculated value?

	(No column name)
	The name of the column used in the calculation
	< N/A >
	The name of the previous column

Question 3 (3 points)

What character is used as the standard concatenation operator in SQL Server?

	|| (double bar)
	& (ampersand)
	+ (plus sign)
	: (colon)

Question 4 (3 points)

Arithmetic operators are processed in SQL according to the standard order of precedence. How can you override this order?

	By using curly brackets {}
	By placing the operations of different lines
	By using parentheses ()
	By using square brackets []

Question 5 (3 points)

Application of the keyword DISTINCT in your SELECT clause has which effects (choose all that apply)?

SELECT DISTINCT VendorCity, VendorState FROM Vendors;

	It removes duplicate rows from the target table
	It automatically sorts by the values in the first column
	It inserts unique values that would otherwise be missing in the results
	It prevents identical rows from being included in the results
	It makes the SELECT keyword unnecessary

Question 6 (3 points)

What is important to remember when using the TOP keyword to limit your results?

SELECT TOP 5 VendorID, InvoiceTotal FROM Invoices ORDER BY InvoiceTotal DESC;

SELECT ALL THAT APPLY:

	Always include an ORDER BY clause
	Always include WITH TIES
	Never use PERCENT
	Never use conditions in the WHERE clause

Question 7 (6 points)

WHERE clause conditions are Boolean (i.e. true or false), and can use a number of different comparison types. Match the SQL comparison operators below with their corresponding definitions:

A	True if the value is greater than or equal to the value that follows
B	True if the value is in the range (inclusive) of the two values that follow
C	True if the value is empty (unavailable or unknown)
D	True if the value matches a string pattern that follows
E	True if the value is less than or equal to the value that follows
F	True if the value is contained in the list of values that follows

1.	IN
2.	BETWEEN
3.	LIKE
4.	>=
5.	IS NULL
6.	<=

Question 8 (3 points)

In SQL Server, a NULL value is equivalent to an empty string ( '' )

	True
	False

Question 9 (3 points)

In the following query, the ORDER BY clause will sort the records in what order?

SELECT VendorName, VendorCity, VendorState, VendorZipCode FROM Vendors ORDER BY VendorState, VendorZipCode DESC, VendorName;

	In descending order by State, then ascending order by ZIP code, then descending order by Name
	In descending order by State, then descending order by ZIP code, then ascending order by Name
	In ascending order by State, then descending order by ZIP code, then ascending order by Name
	In ascending order by State, then ascending order by ZIP code, then descending order by Name