Question

which of following will occupy more space in computer memory 1) bigint 2) integer 3) smallint​

Answer 1

The most fundamental unit of computer memory is the bit. ... For example, the text “hello” would take up 5 bytes of storage, one per character. ... The integer 12,345 would take up 4 bytes (1 word), as would the integers 1 and 12,345,678.

Answer 2

bigint occupy more space in the memory of the computer as its size is of 8 bytes which is 64bits.

Datatypes and the storage required:

• Datatypes are used to store the values of a variable. Datatypes declares the type of value you can store in a variable of a specific data type. And each data type has different storage requirements.

• bigint required 8bytes of memory whereas, integer required 4 bytes of memory, and the smallint requied 2 bytes of memory.

• We can use datatypes according to the need of the data we need to store.

Thus, here among bigint, integer, and smallint, the bigint datatype occupy more space in the memory of the computer.