nerdexam
Oracle

1Z0-071 · Question #124

Which two statements are true regarding single row functions? (Choose two.)

The correct answer is B. TRUNC : can be used with NUMBER and DATE values. D. SYSDATE : returns the database server current date and time. See the full explanation below for the reasoning.

Question

Which two statements are true regarding single row functions? (Choose two.)

Options

  • AMOD : returns the quotient of a division.
  • BTRUNC : can be used with NUMBER and DATE values.
  • CCONCAT : can be used to combine any number of values.
  • DSYSDATE : returns the database server current date and time.
  • EINSTR : can be used to find only the first occurrence of a character in a string.
  • FTRIM : can be used to remove all the occurrences of a character from a string.

How the community answered

(53 responses)
  • A
    2% (1)
  • B
    85% (45)
  • C
    2% (1)
  • E
    4% (2)
  • F
    8% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice