Oracle Database SQL — Question 220

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

Answer options

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

Correct answer: A, D

Explanation

Option A is correct because TRUNC can indeed be applied to both NUMBER and DATE data types. Option D is also correct as CEIL functions correctly for both positive and negative values. Options B and C are incorrect; FLOOR returns the largest integer less than or equal to a number, and MOD returns the remainder of a division operation, not the quotient. Option E is misleading because CONCAT typically combines only two values.