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:
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.
D is true
Correct answer is D
USING (column) When you are specifying an equijoin of columns that have the same name in both tables, the USING column clause indicates the columns to be used. You can use this clause only if the join columns in both tables have the same name.
NATURAL JOIN The NATURAL keyword indicates that a natural join is being performed. A natural join is based on all columns in the two tables that have the same name. It selects rows from the two tables that have equal values in the relevant columns
statement 2 cannot be correct. do you have student_ID in Faculty? if the answer is no, then Natural join cannot be used
C
Correct answer is D