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

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?

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



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Leandro

Leandro

Either the question is malformed or the answer is incorrect.
“You want to generate a report listing the product names and
their corresponding component names, if the component names and product names exist.”
By this statement I understand that products without components should not be considered and vice-versa; nowhere the question is says to retrive one or the other if no relation is found.

donald

donald

all answers are INCORRECT. Try it. Insert a row into Product with a PDTNO (say 100), PDTNAME as NULL, and QTY (say 3). Put a row into COMPONENT with a COMPNO (say 10), COMPNAME (say ‘spoke’) and QTY (say 65). And a PDT_COMP row of PDTNO = 100 and COMPNO = 10. Every option above will return the Product PDTNO = 100 with the COMPONENT = 10… even though the PRODUCT name does NOT exist. The question says … if the component and product names exist!
Very poorly done question.

Naledi

Naledi

do the dumps work though? help i have an exam soon

m

m

Naledi have you given the exam?? Did u get anything from these dumps?

jeddi

jeddi

I have the same question. Are these dumps still valid? If someonr has recently given the exam please let us know