nerdexam
IBM

A2090-614 · Question #55

Which statement about SMS table spaces is correct?

The correct answer is C. SMS table spaces are recommended when you have small tables that are not likely to grow. See the full explanation below for the reasoning.

Question

Which statement about SMS table spaces is correct?

Options

  • AThe system catalog cannot be stored in an SMS table space.
  • BTables, large objects (LOBs), and indexes can each reside in separate SMS table spaces.
  • CSMS table spaces are recommended when you have small tables that are not likely to grow
  • DExtents are more likely to be contiguous with SMS table spaces than they are with DMS table

How the community answered

(37 responses)
  • A
    16% (6)
  • B
    8% (3)
  • C
    73% (27)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice