MENU
How many bytes of storage does a BIGINT data type hold in MySQL?
Suggested Answer: D
Get Premium Data Management - Foundations (D426) Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
In MySQL, the BIGINT data type is a 64-bit integer that requires 8 bytes (64 bits) of storage. It is used to store large numerical values beyond the range of INT (4 bytes).
Option A (Incorrect): 1 byte corresponds to TINYINT, which can store values from -128 to 127.
Option B (Incorrect): 3 bytes is not a standard integer storage size in MySQL.
Option C (Incorrect): 4 bytes corresponds to INT, which has a range of -2,147,483,648 to 2,147,483,647.
Option D (Correct): BIGINT takes 8 bytes and supports a massive range of numbers from -2^63 to 2^63 -1.
30 comments · newest first
IL
Iluminada
6 months ago
Yeah, 8 bytes is standard for BIGINT in MySQL.
MA
Malcolm
6 months ago
Definitely D. It can store huge values!
HA
Hannah
6 months ago
I was torn between C and D, but D feels right.
MI
Micheal
6 months ago
I remember it being 8 bytes too. Good for large numbers.
JE
Jessenia
7 months ago
Agreed! 8 bytes makes sense for BIGINT.
EN
Ena
7 months ago
I think it's D) 8 bytes. BIGINT is large.
MA
Matthew
7 months ago
That's surprising! I didn't realize it was that much.
MA
Maryln
8 months ago
Yup, 8 bytes for BIGINT, no doubt about it.
CH
Christiane
8 months ago
Totally agree, it's definitely 8 bytes!
TA
Talia
8 months ago
BIGINT in MySQL holds 8 bytes.
AM
Amie
8 months ago
D is the way to go. 8 bytes is the only option that makes sense.
BU
Burma
8 months ago
Haha, 1 byte for a BIGINT? What is this, a database for ants?
AL
Alise
8 months ago
D, no doubt. Anything less than 8 bytes would be a "TINYINT" at best.
BL
Blondell
9 months ago
I can't recall exactly, but I thought BIGINT was 4 bytes. I need to double-check my notes on data types.
ST
Stephaine
9 months ago
I’m pretty confident that BIGINT is 8 bytes. I remember it being the same size as a double in some contexts.
ME
Merilyn
9 months ago
I feel like I saw a similar question in our practice tests. I think it was 4 bytes, but now I’m doubting myself.
EL
Elza
9 months ago
I think BIGINT is 8 bytes, but I’m not completely sure. I remember it being one of the larger types.
VI
Vincent
9 months ago
I'm a bit confused on the exact size of BIGINT. I know it's a larger integer type, but I can't recall the specific number of bytes. I'll have to guess and go with C.
GO
Goldie
9 months ago
I remember learning that BIGINT is an 8-byte data type, so I'm confident D is the correct answer.
AR
Arlyne
10 months ago
D) 8 bytes is the correct answer. That's the standard size for a BIGINT in MySQL.
AN
Annice
10 months ago
Okay, let me think this through step-by-step. BIGINT is a larger integer type than INT, which is 4 bytes. So it's likely either 8 bytes or 16 bytes. I'll go with D to be safe.
FL
Floyd
10 months ago
Wait, are you sure? I thought it was 4 bytes.
CA
Callie
10 months ago
Definitely D. I'd be worried if a BIGINT only took 1 or 3 bytes!
ST
Stephaine
11 months ago
Hmm, I'm a little unsure about this one. I know BIGINT is a larger integer type, but I can't remember the exact size. I'll have to think it through.
IR
Ira
11 months ago
I'm pretty sure BIGINT is an 8-byte data type, so I'll go with D.
RE
Regenia
5 months ago
No doubt, it's D. BIGINT is 8 bytes!
DU
Dulce
5 months ago
Agreed! D is the right choice.
AM
Ammie
6 months ago
I remember it being 8 bytes as well.
AD
Adrianna
6 months ago
Yeah, definitely D. That's the standard size.
ER
Eric
10 months ago
I think it's D too. BIGINT is 8 bytes.