122.View the Exhibit for the structure of the STUDENT and FACULTY tables.
You need to display the faculty name followed by the number of students handled by the faculty at the
base location.
Examine the following two SQL statements:
Statement 1
SQL>SELECT faculty_name,COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECT faculty_name,COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;
Which statement is true regarding the outcome?
A.Only s tatement 1 executes successfully and gives the required result.
B.Only statement 2 executes successfully and gives the required result.
C.Both statements 1 and 2 execute successfully and give different results.
D.Both statements 1 and 2 execute successfully and give the same required result.
答案:D
解析:从两个表的结构中可以看出来他们相同名字的字段是faculty_name和location_id,而using使用的
就是这两个字段,因此和natural join是等价的,所以选择D
You need to display the faculty name followed by the number of students handled by the faculty at the
base location.
Examine the following two SQL statements:
Statement 1
SQL>SELECT faculty_name,COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECT faculty_name,COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;
Which statement is true regarding the outcome?
A.Only s tatement 1 executes successfully and gives the required result.
B.Only statement 2 executes successfully and gives the required result.
C.Both statements 1 and 2 execute successfully and give different results.
D.Both statements 1 and 2 execute successfully and give the same required result.
答案:D
解析:从两个表的结构中可以看出来他们相同名字的字段是faculty_name和location_id,而using使用的
就是这两个字段,因此和natural join是等价的,所以选择D