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

Need help with these questions:

Question 1

(TCO 6) To retrieve all fields from a table, use

SELECT ALL.

SELECT ANY.

SELECT ().

SELECT *.

Question 2

(TCO 6) Which operator would be most appropriate to determine the books in the categories of 'COMPUTER', 'SPORTS' and 'FAMILY?'

LIKE

IN

BETWEEN

>

Question 3

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

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

(TCO 6) Given a books table with fields for title, retail, and cost, which statement will correctly display the title of each book and the profit generated with a heading of Profit?

SELECT title, cost-retail as "Profit" FROM books;

SELECT title, retail - cost as "Profit" FROM books;

SELECT title, profit FROM books;

SELECT title, (retail - cost), FROM books;

Question 5

(TCO 8) Which update clause is optional?

SET

UPDATE

WHERE

FROM

Question 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?

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

(TCO 6) Which WHERE clause will return data on all books with 'JAVA' anywhere in the title?

WHERE title LIKE 'JAVA'

WHERE title LIKE 'JAVA%'

WHERE title LIKE '%JAVA%'

WHERE title LIKE '%JAVA'

Question 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 ORDER BY retail WHERE cost > 20;

You must sort and filter on the same field.

You cannot use ORDER BY and WHERE in the same query.

The ORDER BY clause must always be last.

Nothing is wrong.

Question 9

(TCO 8) Which function will convert a number to a character string with a specified number of decimal places?

FORMAT

DATE_FORMAT

NUMBER_FORMAT

FORMAT_NUMBER

Question 10

(TCO 6) Given a books table with fields: title, category (such as 'SPORTS'), cost, retail; what condition will return books with a retail price under 30 in the 'MYSTERY' or 'BIOGRAPHY' categories?

WHERE retail < 30 AND category = 'MYSTERY' OR 'BIOGRAPHY'

WHERE retail < 30 AND category = 'MYSTERY' OR category = 'BIOGRAPHY'

WHERE retail < 30 AND (category = 'MYSTERY' OR category = 'BIOGRAPHY')

WHERE retail < 30 AND category IN 'MYSTERY' OR 'BIOGRAPHY'