Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

WGU Data Management - Foundations Exam - Topic 2 Question 1 Discussion

Actual exam question for WGU's WGU Data Management - Foundations exam
Question #: 1
Topic #: 2
[All WGU Data Management - Foundations Questions]

How many bytes of storage does a BIGINT data type hold in MySQL?

Show Suggested Answer Hide Answer
Suggested Answer: D

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.


Contribute your Thoughts:

0/2000 characters
Malcolm
1 day ago
Definitely D. It can store huge values!
upvoted 0 times
...
Hannah
6 days ago
I was torn between C and D, but D feels right.
upvoted 0 times
...
Micheal
11 days ago
I remember it being 8 bytes too. Good for large numbers.
upvoted 0 times
...
Jessenia
17 days ago
Agreed! 8 bytes makes sense for BIGINT.
upvoted 0 times
...
Ena
22 days ago
I think it's D) 8 bytes. BIGINT is large.
upvoted 0 times
...
Matthew
27 days ago
That's surprising! I didn't realize it was that much.
upvoted 0 times
...
Maryln
2 months ago
Yup, 8 bytes for BIGINT, no doubt about it.
upvoted 0 times
...
Christiane
2 months ago
Totally agree, it's definitely 8 bytes!
upvoted 0 times
...
Talia
2 months ago
BIGINT in MySQL holds 8 bytes.
upvoted 0 times
...
Amie
2 months ago
D is the way to go. 8 bytes is the only option that makes sense.
upvoted 0 times
...
Burma
2 months ago
Haha, 1 byte for a BIGINT? What is this, a database for ants?
upvoted 0 times
...
Alise
2 months ago
D, no doubt. Anything less than 8 bytes would be a "TINYINT" at best.
upvoted 0 times
...
Blondell
3 months ago
I can't recall exactly, but I thought BIGINT was 4 bytes. I need to double-check my notes on data types.
upvoted 0 times
...
Stephaine
3 months ago
I’m pretty confident that BIGINT is 8 bytes. I remember it being the same size as a double in some contexts.
upvoted 0 times
...
Merilyn
3 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.
upvoted 0 times
...
Elza
3 months ago
I think BIGINT is 8 bytes, but I’m not completely sure. I remember it being one of the larger types.
upvoted 0 times
...
Vincent
3 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.
upvoted 0 times
...
Goldie
3 months ago
I remember learning that BIGINT is an 8-byte data type, so I'm confident D is the correct answer.
upvoted 0 times
...
Arlyne
4 months ago
D) 8 bytes is the correct answer. That's the standard size for a BIGINT in MySQL.
upvoted 0 times
...
Annice
4 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.
upvoted 0 times
...
Floyd
4 months ago
Wait, are you sure? I thought it was 4 bytes.
upvoted 0 times
...
Callie
4 months ago
Definitely D. I'd be worried if a BIGINT only took 1 or 3 bytes!
upvoted 0 times
...
Stephaine
5 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.
upvoted 0 times
...
Ira
5 months ago
I'm pretty sure BIGINT is an 8-byte data type, so I'll go with D.
upvoted 0 times
Eric
4 months ago
I think it's D too. BIGINT is 8 bytes.
upvoted 0 times
...
...

Save Cancel