Multiple choice technology databases

Which of the following data types has the least data type precedence?

  1. BIGINT

  2. FLOAT

  3. DECIMAL

  4. MONEY

  5. REAL

  6. NUMERIC
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL Server's data type precedence hierarchy, BIGINT has the lowest precedence among the options. The order from lowest to highest is: BIGINT, INT, SMALLINT, TINYINT, DECIMAL/NUMERIC, MONEY, FLOAT, REAL. When different types interact, the lower precedence type converts to the higher one.

Keep practicing — related questions