Read online free dumps for Oracle- 1z0-061

Here you can read online questions and answers for Oracle Exam 1z0-061 (Oracle Database 12c SQL Fundamentals ) 100% free...

Question ID 2266

Evaluate the following SQL statement:
 
Which statement is true regarding the outcome of the above query?

 

Option A

A.    It executes successfully and displays rows in the descending order of PROMO_CATEGORY.
 

Option B

B.    It produces an error because positional notation cannot be used in the order by clause with set operators.
 

Option C

C.    It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.
 

Option D

D.    It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.
 

Correct Answer D
Description
Update Date and Time 2016-01-05 13:07:58

Question ID 2267

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

A.    JOIN; JOIN
 

Option B

B.    FULL OUTER JOIN; FULL OUTER JOIN
 

Option C

C.    RIGHT OUTER JOIN; LEFT OUTER JOIN

 

Option D

D.    LEFT OUTER JOIN; RIGHT OUTER JOIN

Correct Answer C
Description
Update Date and Time 2016-01-05 13:18:57