1z0-071 Oracle Database 12c SQL 第56题 Natural join

最新推荐文章于 2022-05-04 14:43:13 发布

城风漫漫

最新推荐文章于 2022-05-04 14:43:13 发布

阅读量839

点赞数 1

分类专栏：数据库：Oracle DBA成长之路文章标签： 1z0-071 ocp oracle 11g oracle 12c

数据库：Oracle DBA成长之路专栏收录该内容

165 篇文章 10 订阅

订阅专栏

Q56. 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.

Correct Answer: D
Explanation/Reference:
Explanation:
Natural join needs only one column to be the same in each table. The EMPLOYEES and DEPARTMENTS tables have two columns that are the same (Department_ID and Manager_ID)