CIS 336 STUDY Extraordinary Life/cis336study.com CIS 336 STUDY Extraordinary Life/cis336study.com | Page 11

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

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

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