ocp¿¼ÊÔÌâ¿âÏÂÔØ£º11g-v9.02-051-131Ìâ

ocp¿¼ÊÔÌâ¿âÏÂÔØ£º11g-v9.02-051-131Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

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

ÊÔÌâ½âÎö£º

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±íÖÐËùÓеÄÖµ