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
Corinne
26 days ago
I think C is right, the variable bytes matter.
upvoted 0 times
...
Yesenia
1 month ago
Definitely B, the null vector is crucial!
upvoted 0 times
...
Carli
1 month 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
2 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
2 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
2 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