Test Index

Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

© examsnet.com

Question : 32

Total: 50

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?

Only statement 2 executes successfully and gives the required result
Only statement 1 executes successfully and gives the required result.
Both statements 1 and 2 execute successfully and give different results.
Both statements 1 and 2 execute successfully and give the same required result.

Go to Question:

Prev Question

Next Question