Multiple choice technology databases

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

  1. TRIM

  2. REPLACE

  3. TRUNC

  4. TO_DATE

  5. MOD
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

TRIM removes characters from string ends, and REPLACE substitutes characters within a string - both are character manipulation functions. TRUNC is a numeric function (truncates numbers). TO_DATE converts strings to dates. MOD returns the remainder of division (numeric function).

AI explanation

To answer this question, you need to understand character manipulation functions. Let's go through each option to understand why it is correct or incorrect:

Option A) TRIM - This option is correct because the TRIM function is used to remove leading and trailing spaces from a string.

Option B) REPLACE - This option is correct because the REPLACE function is used to replace a specified substring with another substring in a string.

Option C) TRUNC - This option is incorrect because the TRUNC function is used to truncate a number to a specified number of decimal places.

Option D) TO_DATE - This option is incorrect because the TO_DATE function is used to convert a string to a date value.

Option E) MOD - This option is incorrect because the MOD function is used to find the remainder of a division operation.

The correct answers are Option A) TRIM and Option B) REPLACE. These options are correct because they are character manipulation functions used to modify strings.

Keep practicing — related questions