nerdexam
Oracle

1Z0-071 · Question #341

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

The correct answer is C. TRUNC: can be used with NUMBER and DATE values E. MOD: returns the quotient of a division operation. See the full explanation below for the reasoning.

Question

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

Options

  • ACEIL: can be used for positive and negative numbers
  • BFLOOR: returns the smallest integer greater than or equal to a specified number
  • CTRUNC: can be used with NUMBER and DATE values
  • DCONCAT: can be used to combine any number of values
  • EMOD: returns the quotient of a division operation

How the community answered

(41 responses)
  • A
    17% (7)
  • B
    5% (2)
  • C
    71% (29)
  • D
    7% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice