Multiple choice sql

What's the maximum value can an INT data type hold?

  1. 2,147,483,647

  2. 2,147,483,648

  3. 4,294,967,295

  4. 4,294,967,296
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

INT in SQL Server is a signed 32-bit integer with range -2,147,483,648 to 2,147,483,647. The maximum positive value is 2,147,483,647 (2^31 - 1). Options C and D show values for unsigned 32-bit integers, which SQL Server INT does not support.

AI explanation

A standard 32-bit signed INT can represent values from -2,147,483,648 to 2,147,483,647, so its maximum value is 2,147,483,647 (2^31 - 1). 2,147,483,648 would be one more than the max (it's actually the magnitude of the minimum negative value). 4,294,967,295 and 4,294,967,296 (2^32 and 2^32-1) are the ranges for an UNSIGNED 32-bit integer, not a signed INT, so they don't apply here.

Keep practicing — related questions