AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-001





Question ID 1567

You want to create a report to show different jobs in each department. You do not want to display any duplicate rows in the report. Which SELECT statement do you use to create the report?

Option A

A.    SELECT deptno, job FROM EMP;
 

Option B

B.    SELECT NODUPLICATE deptno, job FROM EMP;
 

Option C

C.    SELECT DISTINCT deptno, job FROM EMP;
 

Option D

D.    CREATE REPORT DISPLAY deptno, job FROM EMP;
 

Option E

E.    SELECT DISTINCT deptno, DISTINCT job FROM EMP;
 

Correct Answer C
Explanation


Question ID 1568

Which should you do after each FETCH statement in a PL/SQL block?

Option A

A.    Open the cursor.
 

Option B

B.    Initialize the loop.

 

Option C

C.    Close the cursor.
 

Option D

D.    Test for rows using a cursor attribute.

Correct Answer D
Explanation

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