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 1601

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,
ROUNDOFF(shipdate - orderdate) "Time Taken" FROM ord;
 

Option B

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

Option C

C.    SELECT custid, orderdate, shipdate,
ROUND(DAYS_BETWEEN (shipdate, orderdate))/ 30) "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 1602

The EMPLOYEE table contains these columns:
BONUSNUMBER(7,2)
DEPT_ID NUMBER(9)
There are 10 departments and each department has at least 1 employee. Bonus values are greater than 500; not all employees receive a bonus.
Evaluate this PL/SQL block:
DECLARE
v_bonusemployee.bonus%TYPE := 300;
BEGIN
UPDATE employee
SET bonus = bonus + v_bonus
WHERE dept_id IN (10, 20, 30);
COMMIT;
END;
What will be the result?
 

Option A

A.    A subset of employees will be given a 300 bonus.
 

Option B

B.    All employees will be given a 300 increase in bonus.
 

Option C

C.    A subset of employees will be given a 300 increase in bonus.

 

Option D

D.    All employees will be given a 300 bonus.

Correct Answer C
Explanation

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