Multiple choice technology databases

Arithmetic functions returns a NULL for a NULL input...

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL arithmetic functions follow NULL propagation semantics, meaning any operation involving a NULL input returns NULL. This is because NULL represents an unknown value, and mathematical operations on unknown values cannot produce determinate results. This behavior applies to arithmetic operations and most built-in SQL functions.

Keep practicing — related questions