1z0-071 Oracle Database 12c SQL 第49题 OUTER JOIN

最新推荐文章于 2019-12-02 12:55:38 发布

转载最新推荐文章于 2019-12-02 12:55:38 发布 · 1.3k 阅读

标签

#1z0-071 #ocp #oracle 11g #oracle 12d

收录于

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

165 篇文章

订阅专栏

本文探讨了如何使用SQL语句查询所有部门ID及其关联的课程ID，通过对比不同类型的外连接，明确了左外连接在此场景下的正确应用。

Q49. Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS:
SQL>CREATE TABLE DEPARTMENT_DETAILS
(DEPARTMENT_ID NUMBER PRIMARY KEY,
DEPARTMENT_NAME VARCHAR2(50),
HOD VARCHAR2(50));
SQL>CREATE TABLE COURSE_DETAILS
(COURSE_ID NUMBER PRIMARY KEY,
COURSE_NAME VARCHAR2(50),
DEPARTMENT_ID VARCHAR2(50));
You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?
A. SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON
(d.department_id=c. department_id);
B. SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON
(d.department_id=c. department_id);
C. SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON
(c.department_id=d. department_id);
D. SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON
(c.department_id=d. department_id);