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)- A73% (19)
- B4% (1)
- C15% (4)
- D8% (2)
Community Discussion
No community discussion yet for this question.