多项选择题
以下是课程(CLASS)表和教师(INSTRUCTOR)表中的数据:
CLASS |
CLASS_ID | CLASS_NAME | HOURS_CREDIT | INSTRUCTOR_ID |
1 | Introduction to Accounting | 3 | 4 |
2 | Computer Basics | 3 | 1 |
3 | Tax Accounting Principles | 3 | 4 |
4 | American History | 3 | 2 |
5 | Basic Engineering | 3 | |
INSTRUCTOR |
INSTRUCTOR_ID | LAST_NAME | FIRST_NAME |
1 | Chao | Ling |
2 | Vanderbilt | Herbert |
3 | Wigley | Martha |
4 | Page | Albert |
要生成一个包括每个教师所教课程的报表,该报表必须包括所有的教师,即使那些目前没有任课的教师也要包括在报表中。请问,应使用以下查询语句中的哪两个
A.SELECT i.last_name, i.first_name, c.class_name
FROM instructor i, class c;
B.SELECT i.last name, i.first_name,c.class_name
FROM class c LEFT OUTER JOIN instructor I
ON (i.instructor_id=c.instructor_id)
ORDER BY i.instructor_id;
C.SELECT i.last_name, i.first_name, c.class_name
FROM instructor i, class c
WHERE i.instructor_id=c.instructor_id (+)
ORDER BY i.instructor_id;
D.SELECT i.last_name, i.first_name, c.class_name
FROM instructor i LEFT OUTER JOIN class c
ON (i.instructor id=c.instructor_id)
ORDER BY i.instructor_id;
E.SELECT i.last_name, i.first_name, c.class_name
FROM instructor i, class c
WHERE i.instructor_id (+)=c.instructor_id
ORDER BY i.instructor_id;
F.SELECT i.last_name, i.first_name, c.class_name
FROM instructor i NATURAL JOIN class c
ON (i.instructor_id=c.instructor_id);