Multiple choice technology databases

Which one of them is not an String Function?

  1. SOUNDEX

  2. DIFFERENCE

  3. GROUPING

  4. SUBSTRING
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

GROUPING is not a string function - it's used with ROLLUP and CUBE operations to distinguish between NULL values representing group totals and actual NULL data. SOUNDEX evaluates sound similarity, DIFFERENCE compares soundex patterns, and SUBSTRING extracts character strings - all legitimate string functions. GROUPING is an aggregate/analytic function.

Keep practicing — related questions