CIS 336 All Assignments CIS 336 All Assignments | Page 10

ADD CONSTRAINT devry_studentcity_fk FOREIGN KEY (student_city) references city;
ALTER table DEVRY
ADD CONSTRAINT FOREIGN KEY (student_city) references city;
8. (TCO 7) Given a table named EMPLOYEE, the SQL command to sort records in a specific order
would be: (Points : 4)
SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE
FROM EMPLOYEE
LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE
FROM EMPLOYEE
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