Oracle
1Z0-007 · Question #77
Which SQL statement returns a numeric value?
The correct answer is C. SELECT sysdate-hire_date. DATE value subtract DATE value will return numeric value. Incorrect answer: A does not return numeric value B does not return numeric value D does not return numeric value
Using Functions (Single-Row, Group, Conversion, Conditional)
Question
Which SQL statement returns a numeric value?
Options
- ASELECT ADD_MONTHS(MAX(hire_Date), 6)
- BSELECT ROUND(hire_date)
- CSELECT sysdate-hire_date
- DSELECT TO_NUMBER(hire_date + 7)
How the community answered
(19 responses)- A5% (1)
- B5% (1)
- C79% (15)
- D11% (2)
Explanation
DATE value subtract DATE value will return numeric value. Incorrect answer: A does not return numeric value B does not return numeric value D does not return numeric value
Topics
#date arithmetic#numeric return type#SYSDATE#data type conversions
Community Discussion
No community discussion yet for this question.