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-007





Question ID 1670

Evaluate the SQL statement:
SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual;
Which values are displayed?
 

Option A

A.    45.95 and 45.93

 

Option B

B.    50 and 45.93
 

Option C

C.    46 and 45
 

Option D

D.    50 and 45.9

Correct Answer B
Explanation


Question ID 1671

Which SQL statement returns a numeric value?

Option A

A.    SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;

 

Option B

B.    SELECT sysdate-hire_date FROM EMP;
 

Option C

C.    SELECT TO_NUMBER(hire_date + 7) FROM EMP;
 

Option D

D.    SELECT ROUND(hire_date) FROM EMP;

Correct Answer B
Explanation

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