Examveda
Examveda

The BIGINT precision is of bit . . . . . . . .

A. 32

B. 64

C. 128

D. 16

Answer: Option B

Solution(By Examveda Team)

64: The BIGINT data type in MySQL has a precision of 64 bits. This means it can store integer values ranging from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807, inclusive, which requires 64 bits to represent in binary form.
32: This option is incorrect. The precision of 32 bits is typically associated with the INT data type, not BIGINT.
128: This option is incorrect. While there are data types in MySQL that support precision up to 128 bits (such as DECIMAL), the BIGINT data type specifically has a precision of 64 bits.
16: This option is incorrect. The precision of 16 bits is insufficient to represent the range of values that the BIGINT data type can accommodate.

Therefore, the precision of the BIGINT data type in terms of bits is Option B: 64.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous