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

IBM C1000-085 Exam - Topic 4 Question 95 Discussion

When computing the row size for a table row, what overhead should be accounted for?
A) 48 bytes for ROWID, CREATEXID and DELETEXID only
B) 32 bytes for ROWID. CREATEXID, DELETEXID and the null vector
C) 32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns
D) 24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns

IBM C1000-085 Exam - Topic 4 Question 95 Discussion

Actual exam question for IBM's C1000-085 exam
Question #: 95
Topic #: 4
[All C1000-085 Questions]

When computing the row size for a table row, what overhead should be accounted for?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

0/2000 characters
Tresa
7 hours ago
Definitely B, the null vector is crucial!
upvoted 0 times
...
Lashawn
5 days ago
A is way off, it’s more than just those three!
upvoted 0 times
...
Aliza
11 days ago
Nah, D is too complicated for just overhead.
upvoted 0 times
...
Elmer
16 days ago
Surprised that people forget the null vector!
upvoted 0 times
...
Corinne
2 months ago
I think C is right, the variable bytes matter.
upvoted 0 times
...
Yesenia
2 months ago
Definitely B, the null vector is crucial!
upvoted 0 times
...
Carli
3 months ago
I’m leaning towards option B, but I’m confused about whether the record header is always part of the overhead calculation.
upvoted 0 times
...
Jennie
3 months ago
I feel like I saw something about 32 bytes being a standard for ROWID and transaction IDs, but I can't recall if the null vector adds more.
upvoted 0 times
...
Margart
3 months ago
I remember practicing a similar question, and I think the null vector is only included if there are nullable columns. So maybe it's option C?
upvoted 0 times
...
Wilda
3 months ago
I think the overhead includes the ROWID and the transaction IDs, but I’m not sure if the null vector is always counted.
upvoted 0 times
...

Save Cancel