The transformation functions used are
-
CONVERT
-
TRANSLATE
-
DECODE
-
Both B. and C.
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.