Oracle Database Administration I — Question 43

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

Answer options

• A. MOD : returns the quotient of a division operation
• B. FLOOR : returns the smallest integer greater than or equal to a specified number
• C. TRUNC : can be used with NUMBER and DATE values
• D. CONCAT : can be used to combine any number of values
• E. CEIL : can be used for positive and negative numbers

Correct answer: C, E

Explanation

The correct answer is C and E because TRUNC can indeed operate on both NUMBER and DATE data types, while CEIL can be used on both positive and negative numbers. The other options are incorrect as MOD does not return the quotient but the remainder, FLOOR returns the largest integer less than or equal to a number, and CONCAT is limited to combining two values rather than any number.