CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your 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