nerdexam
Oracle

1Z0-160 · Question #33

Which two statements are true regarding single row functions?

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?

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

(27 responses)
  • A
    7% (2)
  • B
    70% (19)
  • C
    15% (4)
  • E
    4% (1)
  • F
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-160 Practice