Prev Question
Next Question

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.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *