OCP-1Z0-051-V9 02-131题

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

131. View the Exhibit and examine the structure of the PRODUCT, COMPONENT, and PDT_COMP

tables.

In PRODUCT table, PDTNO is the primary key.

In COMPONENT table, COMPNO is the primary key.

In PDT_COMP table, (PDTNO,COMPNO) is the primary key, PDTNO is the foreign key referencing

PDTNO in PRODUCT table and COMPNO is the foreign key referencing the COMPNO in COMPONENT

table.

You want to generate a report listing  the product names and their corresponding component names, if the

component names and product names exist.

Evaluate the following query:

SQL>SELECT pdtno,pdtname, compno,compname

FROM product _____________ pdt_comp

USING (pdtno) ___________ component USING(compno)

WHERE compname IS NOT NULL;

Which combination of joins used in the blanks in the above query gives the correct output? 

A. JOIN; JOIN

B. FULL OUTER JOIN; FULL OUTER JOIN

C. RIGHT OUTER JOIN; LEFT OUTER JOIN 外键的关系

D. LEFT OUTER JOIN; RIGHT OUTER JOIN

Answer: C

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12877591

listing the product names and their corresponding component names, if the

component names and product names exist

报表显示的是如果component names和product names存在，则显示product names和对应的component names

即显示PDT_COMP表中所有的值

           

给我老师的人工智能教程打call！http://blog.csdn.net/jiangjunshow