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 1536

You need to analyze how long your orders take to be shipped from the date that the order is placed. To do this, you must create a report that displays the customer number, date ordered, date shipped, and the number of months in whole numbers from the time the order is placed to the time the order is shipped. Which statement produces the required results?

Option A

A.    SELECT custid, orderdate, shipdate,
ROUND(DAYS_BETWEEN (shipdate, orderdate))/ 30) "Time Taken" FROM ord;
 

Option B

B.    SELECT custid, orderdate, shipdate,
ROUNDOFF(shipdate - orderdate) "Time Taken" FROM ord;
 

Option C

C.    SELECT custid, orderdate, shipdate,
MONTHS_BETWEEN (shipdate, orderdate)"Time Taken"
FROM ord;
 

Option D

D. SELECT custid, orderdate, shipdate,
ROUND(MONTHS_BETWEEN (shipdate, orderdate))
"Time Taken" FROM ord;
 

Correct Answer D
Explanation


Question ID 1537

In which situation should you use an outer join query?

Option A

A.    The employee table column corresponding to the region table column contains null values for rows that need to be displayed.
 

Option B

B.    The employee table has two columns that correspond.
 

Option C

C.    The employee and region tables have corresponding columns.

 

Option D

D.    The employee and region tables have no corresponding columns.

Correct Answer A
Explanation

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