CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 11

2. (TCO 7) Which of the following keywords can be used to join two tables that do not
contain a commonly named and defined column? (Points : 4)
NATURAL JOIN
JOIN...ON
JOIN...USING
JOIN...WHERE
3. (TCO 8) Based upon the contents of the BOOKS table shown below, which of the
following SQL statements will return the number of categories contained in the table?
(Points : 4)
SELECT COUNT(DISTINCT category) FROM books;
SELECT DISTINCT COUNT(category) FROM books;
SELECT DISTINCT (COUNT(category)) FROM books;
SELECT DISTINCT COUNT(category) FROM books;
4. (TCO 8) The _____________ function can be used to display upper-case characters in
lower-case. (Points : 4)
CONVERT
MIN
LESS
LOWER
5. (TCO 8) Which of the following statements will produce