CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/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