CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 11

FROM EMPLOYEE

DISPLAY BY EMP _ LNAME , EMP _ FNAME , EMP _ INITIAL ;

SELECT EMP _ LNAME , EMP _ FNAME , EMP _ INITIAL , EMP _ AREACODE , EMP _ PHONE

FROM EMPLOYEE

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