nerdexam
Oracle

1Z0-061 · Question #248

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.

Using Single-Row Functions to Customize Output

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

(35 responses)
  • A
    3% (1)
  • B
    9% (3)
  • C
    74% (26)
  • D
    14% (5)

Explanation

DATE value subtract DATE value will return numeric value.

Topics

#date arithmetic#numeric return#SYSDATE#date functions

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-061 Practice