Multiple choice technology programming languages

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 character transformation functions available in SQL (particularly Oracle). TRANSLATE replaces characters in a string based on a mapping, while DECODE performs if-then-else conditional logic (similar to CASE). CONVERT is typically used for data type conversion (like converting a string to a date), not character transformation, making 'Both B and C' the correct answer.

Keep practicing — related questions