View the exhibit for the structure of the STUDENT and FACULTY tables.
STUDENT
Name Null? Type
—————— ——————- ————-
STUDENT_ID NOT NULL NUMBER(2)
STUDENT_NAME VARCHAR2(20)
FACULTY_ID VARCHAR2(2)
LOCATION_ID NUMBER(2)
FACULTY
Name Null? Type
—————— ——————- ————-
FACULTY_ID NOT NULL NUMBER(2)
FACULTY_NAME VARCHAR2(20)
LOCATION_ID NUMBER(2)
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 statement 2 executes successfully and gives the required result.
B.
Only statement 1 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.
The correct answer is D. The both statements execute successfully and give the same required result OR… if there is character data in FACULTY_ID then both fail.
I agree with Nikolay: https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljnaturaljoin.html
Both queries should execute sucessfully and give the required result.
D should be the correct answer.
The correct choice is D.
I did the test and confirmed the result.
Both queries will execute sucessfully and will give the desired result.
No matter if you use NATURAL JOIN or JOIN USING (faculty_id, location_id).
In both cases the two tables will be joined using faculty_id and location_id columns.
I think C is right answer, because FACULTY_ID has different datatype VARCHAR2(2) and NUMBER(2)