Using the SQL ORDER BY Clause - Quiz

Each question is worth one point. Select the best answer or answers for each question.

For this quiz, please refer to the following table, named Orders. All four questions reference this table.

OrderNum	ItemNum	Date	Qty	CustID
4332	1001	12/31/97	5	0001
4321	1001	01/10/98	1	1231
4332	1002	12/31/97	1	0001
4333	1003	01/15/98	1	0002
4321	1010	01/10/98	10	1231
4334	1011	01/10/98	1	1231
4335	1231	01/15/98	1	4325
4335	1001	01/15/98	1	4325

Which statement below will return only the OrderNum and ItemNum columns from this table?
Please select the best answer.

A. SELECT * FROM Orders WHERE COLUMN NAMES = 'OrderNum', 'ItemNum'

B. SELECT * FROM Orders

C. SELECT COLUMNS OrderNum, ItemNum FROM Orders

D. SELECT OrderNum, ItemNum FROM Orders

2.	Using the Orders table above, which statement will return only those rows where CustID = 0001? Please select the best answer.
	A.	`SELECT CustID=0001 FROM Orders`
	B.	`SELECT * FROM Orders WHERE CustID=0001`
	C.	`SELECT * FROM Orders IF CustID=0001`
	D.	`SELECT * FROM Orders ORDER BY CustID=0001`

3.	Using the Orders table above, which statement will extract the OrderNum and ItemNum columns and place them into a new table named new_Orders? Please select the best answer.
	A.	`SELECT OrderNum AND ItemNum FROM Orders INTO new_Orders`
	B.	`SELECT INTO new_Orders COLUMNS OrderNum, ItemNum FROM Orders`
	C.	`SELECT OrderNum, ItemNum INTO new_Orders FROM Orders`
	D.	`SELECT OrderNum, ItemNum INTO new_Orders`

4.	Using the Orders table above, select all rows and columns sorted by Qty so that the largest value appears first and smaller values come last. Which statement will accomplish this? Please select the best answer.
	A.	`SELECT * FROM Orders ORDER BY Qty`
	B.	`SELECT * FROM Orders ORDER BY Qty DESC`
	C.	`SELECT * FROM Orders SORT BY Qty DESC`
	D.	`SELECT * FROM Orders DESC ORDER BY Qty`