CIS 336 All Assignments CIS 336 All Assignments | 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 the value 21.1? (Points : 4)
SELECT ROUND(21.12, 1) FROM dual;
SELECT ROUND(21.12, -1) FROM dual;
SELECT ROUND(21.12, 0) FROM dual;
SELECT ROUND(21.12, 0+) FROM dual;
6. (TCO 9) The column to be updated by the UPDATE command is specified in the ______
clause. (Points : 4)