Multiple choice technology databases

The modulos operator (%) CANNOT be used on the _____ datatype.

  1. Tinyint

  2. Money

  3. Float

  4. Smallint

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL Server, the modulo operator (%) cannot be used with money or smallmoney datatypes because these represent fixed-point decimal currency values rather than integers. All other listed types (tinyint, smallint, float) support the modulo operation correctly.