Home » Oracle » 1z0-051 » Which SQL statement returns a numeric value?
Which SQL statement returns a numeric value?
A. SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
B. SELECT ROUND(hire_date) FROM EMP;
C. SELECT sysdate-hire_date FROM EMP;
D. SELECT TO_NUMBER(hire_date + 7) FROM EMP;
Correct Answer: C
Explanation/Reference:
Explanation:
DATE value subtract DATE value will return numeric value.
Incorrect answer:
Adoes not return numeric value
Bdoes not return numeric value
Ddoes not return numeric value
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 9-13
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
