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

TRIM removes leading/trailing characters from strings, and REPLACE substitutes occurrences of a substring. These operate on character data, while TRUNC is for numbers, TO_DATE converts data types, MOD performs math, and CASE is conditional logic.

AI explanation

To answer this question, we need to understand the functions and their purpose in character manipulation.

Option A) TRIM - This option is correct. The TRIM function is used to remove specified characters (usually spaces) from the beginning and end of a string.

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

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

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

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

Option F) CASE - This option is incorrect. The CASE statement is used for conditional logic and does not manipulate characters directly.

The correct answers are A) TRIM and B) REPLACE. These functions are used for character manipulation by removing specified characters or replacing substrings within a string.

Keep practicing — related questions