Multiple choice technology databases

Which two are character manipulation functions? (Choose two.)

  1. TRIM

  2. REPLACE

  3. TRUNC

  4. TO_DATE

  5. MOD

  6. CASE
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

Character manipulation functions operate on string/text data. TRIM removes leading/trailing characters (typically whitespace). REPLACE substitutes occurrences of a substring. TRUNC is for numeric truncation. TO_DATE converts strings to dates. MOD performs arithmetic modulo. CASE is conditional expression logic, not string manipulation.

Keep practicing — related questions