View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.
The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, the following SQL statement was written:
SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;
The desired output is not obtained after executing the above SQL statement. What could be the reason for this?
A. The table prefix is missing for the column names in the SELECT clause.
B. The NATURAL JOIN clause is missing the USING clause.
C. The DEPARTMENTS table is not used before the EMPLOYEES table in the FROM clause.
D. The EMPLOYEES and DEPARTMENTS tables have more than one column with the same column name and data type.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
D ???
SQL> select *
2 from
3 ( select 1 as f1, 2 as f2 from dual ) t1
4 natural join
5 ( select 1 as f1, 2 as f2 from dual ) t2;
F1 F2
———- ———-
1 2
In your situation we get desired output , but here on employees and departments table we get diffrent output than expected. because natural join uses manager_id as join column , not department_id
Better to say natural join uses both department_id and manager_id.