nerdexam
IBM

C2090-320 · Question #37

When you add an XML column to a table by using an ALTER TABLE statement, which of the following are TRUE? (Choose two.)

The correct answer is A. DB2 implicitly creates an XML table space E. If this is the first XML column you created for the table, DB2 implicitly creates a BIGINT node ID. See the full explanation below for the reasoning.

Question

When you add an XML column to a table by using an ALTER TABLE statement, which of the following are TRUE? (Choose two.)

Options

  • ADB2 implicitly creates an XML table space
  • BDB2 implicitly creates an AUX table to store the XML data
  • CIf this is the first XML column you created for the table, DB2 implicitly creates a unique index on the
  • DIf this is the first XML column you created for the table, DB2 implicitly creates a ROWID column on
  • EIf this is the first XML column you created for the table, DB2 implicitly creates a BIGINT node ID

How the community answered

(26 responses)
  • A
    73% (19)
  • B
    4% (1)
  • C
    15% (4)
  • D
    8% (2)

Community Discussion

No community discussion yet for this question.

Full C2090-320 Practice