CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 11

SEQUENCE BY EMP_LNAME, EMP_FNAME,
EMP_INITIAL;
Page 3 - Multiple Choice
1. (TCO 7) Which of the following subqueries returns
more than one row of results to the outer query? (Points :
4)
multiple-column subquery
single-row subquery
multiple-row subquery
correlated subquery
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;