IBM
A2090-614 · Question #35
Which statement about Range-Clustered Tables (RCTs) is correct?
The correct answer is C. Space is pre-allocated and reserved for use by the table even when records do not yet exist. See the full explanation below for the reasoning.
Question
Which statement about Range-Clustered Tables (RCTs) is correct?
Options
- AMore logging is required compared to similarly-sized regular tables.
- BMore buffer pool memory is required to store the table's B+ index structure.
- CSpace is pre-allocated and reserved for use by the table even when records do not yet exist.
- DMore maintenance is required since indexes must be updated after every insert, update, or delete
How the community answered
(51 responses)- A2% (1)
- B6% (3)
- C82% (42)
- D10% (5)
Community Discussion
No community discussion yet for this question.