Multiple choice technology databases

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

  1. TO_CHAR

  2. LOWER

  3. LPAD

  4. MAX

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

LPAD can accept string or numeric arguments because Oracle implicitly converts numbers to strings when needed for padding operations. LOWER and TO_CHAR only work on character/string types, MAX is an aggregate function requiring a specific datatype context, and CEIL operates only on numbers. LPAD's signature allows it to handle inputs from multiple datatypes through implicit conversion.

Keep practicing — related questions