Examveda

What is the precision of BIGINT?

A. 32

B. 64

C. 128

D. 16

Answer: Option B

Solution (By Examveda Team)

This question asks about the precision of the BIGINT data type in MySQL.

Precision refers to the total number of digits a data type can store, including both the integer part and any decimal places.
BIGINT is a data type used to store large whole numbers (integers). It can handle very large numbers, but it doesn't have any decimal places.
Let's look at the options:
Option A: 32 - This is the precision of the INT data type, not BIGINT.
Option B: 64 - This is the correct answer! BIGINT in MySQL can store whole numbers with a precision of 64 bits.
Option C: 128 - This is too large for BIGINT.
Option D: 16 - This is the precision of the SMALLINT data type, not BIGINT.
Therefore, the correct answer is Option B: 64.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous