Multiple choice technology

The transformation functions used are

  1. CONVERT

  2. TRANSLATE

  3. DECODE

  4. Both B. and C.

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

TRANSLATE and DECODE are both SQL transformation functions. TRANSLATE performs character-by-character string replacement, while DECODE evaluates conditions to return different values (similar to CASE statement). CONVERT is typically used for data type conversion, not character transformation.