1. (TCO 6) To retrieve all fields from a table, use (Points : 3) SELECT ALL. SELECT ANY. SELECT (). SELECT *.

Question 2. 2. (TCO 6) Which operator would be most appropriate to determine books with a retail price of more than $25? (Points : 3)

LIKE IN BETWEEN >

Question 3. 3. (TCO 6) Which code returns the date field HIREDATE in the format: Friday, April 5th, 2015? (Points : 3)

DATE_FORMAT(HIREDATE, '%W, %m %d, %Y') DATE_FORMAT(HIREDATE, '%a, %M %D, %Y') DATE_FORMAT(HIREDATE, '%W, %M %D, %Y') DATE_FORMAT(HIREDATE, '%a, %m %d, %y')

Question 4. 4. (TCO 6) Given a customer table with fields for firstname and lastname, which of the following will display the customer name as a single field in the format Jones, Tom with a heading? (Points : 3)

SELECT CONCAT(lastname, firstname) as Name FROM customer; SELECT CONCAT(firstname, lastname) as Name FROM customer; SELECT CONCAT(lastname, , , firstname) as Name FROM customer; SELECT CONCAT lastname , firstname as Name FROM customer;

Question 5. 5. (TCO 8) Which update clause is optional? (Points : 3)

SET UPDATE WHERE FROM

Question 6. 6. (TCO 6) Given a table orders with fields for orderid, orderdate, and shipdate, which query will display the ordered for only those orders that have shipped? (Points : 3)

SELECT ordered FROM orders WHERE shipdate <> orderdate; SELECT orderid FROM orders WHERE shipdate IS NOT NULL; SELECT orderid FROM orders WHERE shipdate IS NULL; SELECT orderid FROM orders;

Question 7. 7. (TCO 6) Which WHERE clause will return data on all employees whose last name starts with Smith? (Points : 3)

WHERE lastname LIKE Smith WHERE lastname LIKE Smith% WHERE lastname LIKE %Smith% WHERE lastname LIKE %Smith

Question 8. 8. (TCO 6) Given a books table with fields of title, cost, and retail, what if anything is wrong with the following query (assuming all fields exist)? SELECT * FROM books WHERE cost > 20 ORDER BY retail; (Points : 3)

You must sort and filter on the same field. You cannot use ORDER BY and WHERE in the same query. The WHERE clause must always be last. Nothing is wrong.

Question 9. 9. (TCO 8) You can delete one or more rows in a table by using the _____ command. (Points : 3)

UPDATE DROP DELETE ALTER

Question 10. 10. (TCO 6) Given a books table with fields: title, category (such as SPORTS), cost, retail; what condition will return COMPUTER books with a retail price between $50 and $100 ? (Points : 3)

WHERE retail > 50 AND < 100 AND category = COMPUTER WHERE category = COMPUTER AND (retail BETWEEN 100 and 50) WHERE category = COMPUTER AND retail < 50 AND retail > 100 WHERE category = COMPUTER AND ( retail BETWEEN 50 AND 100)