nerdexam
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)
  • A
    2% (1)
  • B
    6% (3)
  • C
    82% (42)
  • D
    10% (5)

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice