CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com | Page 10

ALTER table DEVRY
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