IBM C1000-085 Exam - Topic 4 Question 95 Discussion

Actual exam question for IBM's C1000-085 exam

Question #: 95
Topic #: 4

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

A48 bytes for ROWID, CREATEXID and DELETEXID only

B32 bytes for ROWID. CREATEXID, DELETEXID and the null vector

C32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns

D24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns

Show Suggested Answer

Suggested Answer: A

by Altha at Apr 07, 2026, 03:40 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

10 days ago

I think C is right, the variable bytes matter.

upvoted 0 times

...

15 days ago

Definitely B, the null vector is crucial!

upvoted 0 times

...

29 days 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

...

1 month 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

...

1 month 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

...

1 month 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

...