Multiple choice technology programming languages

Which one is the character manipulation function?

  1. TRUNC

  2. REPLACE

  3. TO_DATE

  4. MOD

  5. CASE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

REPLACE is a character manipulation function that substitutes one substring with another within a string. TRUNC operates on numbers by truncating decimal places, not character strings. TO_DATE converts strings to date format, MOD performs mathematical modulo operations, and CASE provides conditional logic - none of these directly manipulate character content.

AI explanation

REPLACE is a character/string manipulation function — it substitutes occurrences of a substring within a string. TRUNC truncates numbers or dates, TO_DATE converts a string to a date, MOD returns a numeric remainder, and CASE is a conditional expression — none of these operate on character data the way REPLACE does.

Keep practicing — related questions