Oracle Database Administration I — Question 114

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

Answer options

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

Correct answer: A, B

Explanation

The correct answers are A and B because CEIL can indeed handle both positive and negative numbers, and MOD effectively returns the remainder after division. Options C, D, and E are incorrect as CONCAT is limited to two values, FLOOR returns the largest integer less than or equal to a number, and TRUNC is not restricted to just NUMBER data types.