Multiple choice technology databases

Which of these is not a Single-Row Function?

  1. Character Function

  2. Number Function

  3. String Function

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

Standard SQL function categories are Character (UPPER, LOWER, SUBSTR), Number (ROUND, TRUNC, MOD), Date (SYSDATE, ADD_MONTHS, LAST_DAY), and Conversion (TO_CHAR, TO_DATE). There is no separate 'String Function' category - character functions handle string manipulation.

AI explanation

In Oracle SQL, single-row functions are officially grouped into categories: Character functions, Number functions, Date functions, Conversion functions, and General/NULL-handling functions. "String Function" is not a distinct, separately-named category in Oracle's own taxonomy — string manipulation (UPPER, SUBSTR, CONCAT, etc.) falls under "Character functions." So among the four choices, "String Function" is the one that isn't a recognized single-row function category name, while Character, Number, and Date functions are all legitimate, standard groupings. The question is testing recall of Oracle's specific terminology rather than a deep conceptual distinction.

Keep practicing — related questions