nerdexam
IBM

A2090-614 · Question #19

A DBA wants to create a set of tables in a storage group named SG_1, but no table spaces have been assigned to this group. What kind of table spaces must the DBA assign to the storage group before…

The correct answer is A. Automatic storage (AS) table spaces. See the full explanation below for the reasoning.

Question

A DBA wants to create a set of tables in a storage group named SG_1, but no table spaces have been assigned to this group. What kind of table spaces must the DBA assign to the storage group before the desired tables can be created?

Options

  • AAutomatic storage (AS) table spaces
  • BSystem managed space (SMS) table spaces
  • CDatabase managed space (DMS) table spaces that use FILE containers
  • DDatabase managed space (DMS) table spaces that use RAW containers

How the community answered

(25 responses)
  • A
    80% (20)
  • B
    4% (1)
  • C
    12% (3)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice