Multiple choice technology

Which data types are supported as input for the ROUND ( ) function?

  1. Decimal

  2. Decimal, Double, Real

  3. Date/Time, Decimal, Double

  4. Decimal, Double, Integer, Small Integer, Real

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Informatica's ROUND function handles both numeric and Date/Time types. For numeric types (Decimal, Double, etc.), it rounds to the specified precision. For Date/Time types, it rounds to the nearest date format (year, quarter, month, etc.).