READ Free Dumps For Oracle- 1z0-061

Question ID 20998	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?
Option A	JOIN; JOIN
Option B	FULL OUTER JOIN; FULL OUTER JOIN
Option C	RIGHT OUTER JOIN; LEFT OUTER JOIN
Option D	LEFT OUTER JOIN; RIGHT OUTER JOIN
Correct Answer	C

Explanation

Question ID 20999	View the Exhibits and examine products and sales tables. You issue the following query to display product name and the number of times the product has been sold: What happens when the above statement is executed?
Option A	The statement executes successfully and produces the required output.
Option B	The statement produces an error because item_cnt cannot be displayed in the outer query.
Option C	The statement produces an error because a subquery in the from clause and outer-joins cannot be used together.
Option D	The statement produces an error because the group by clause cannot be used in a subquery in the from clause.
Correct Answer	A

Explanation

Previous-Page 1 2. . . 31 32 33 34 35 36 37. . . 58 59 Next-Page

Send email to admin@getfreedumps for new dumps request!!!