Multiple choice technology databases

Which of the following SQL functions can operate on any datatype?

  1. TO_CHAR

  2. LOWER

  3. MAX

  4. CEIL

  5. LPAD
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

MAX is an aggregate function that can operate on any standard data type including numbers, strings, and dates. Functions like CEIL require numbers, LOWER and LPAD require strings, and TO_CHAR does not accept all raw datatypes directly in the same way.

Keep practicing — related questions