CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 13

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;