nerdexam
Oracle

1Z0-082 · Question #101

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

The correct answer is A. MOD : returns the quotient of a division operation C. TRUNC : can be used with NUMBER and DATE values. https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Single-Row- Functions.html#GUID-B93F789D-B486-49FF-B0CD-0C6181C5D85C

SQL and PL/SQL

Question

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

Options

  • AMOD : returns the quotient of a division operation
  • 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
  • ECEIL : can be used for positive and negative numbers

How the community answered

(28 responses)
  • A
    71% (20)
  • B
    11% (3)
  • D
    4% (1)
  • E
    14% (4)

Explanation

https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Single-Row- Functions.html#GUID-B93F789D-B486-49FF-B0CD-0C6181C5D85C

Topics

#single row functions#numeric functions#TRUNC#date functions

Community Discussion

No community discussion yet for this question.

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