nerdexam
IBM

C2090-610 · Question #3

When an index is created for a table, where is the metadata for that index stored?

The correct answer is B. In the system catalog. See the full explanation below for the reasoning.

Question

When an index is created for a table, where is the metadata for that index stored?

Options

  • AIn the table definition.
  • BIn the system catalog.
  • CIn the schema that the index resides in.
  • DIn the metadata of the table the index was created for.

How the community answered

(61 responses)
  • A
    8% (5)
  • B
    70% (43)
  • C
    16% (10)
  • D
    5% (3)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice