IBM
C2090-600 · Question #51
When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)
The correct answer is D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN. E. The INTRA_PARALLEL database manager configuration parameter is set to NO. See the full explanation below for the reasoning.
Question
When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)
Options
- AThe PAGESIZE database configuration parameter is set to 32K.
- BThe AUTO_REORG database configuration parameter is set to NO.
- CThe DFT_EXTENT_SZ database configuration parameter is set to 8.
- DThe DFT_TABLE_ORG database configuration parameter is set to COLUMN.
- EThe INTRA_PARALLEL database manager configuration parameter is set to NO.
How the community answered
(39 responses)- A3% (1)
- B13% (5)
- C5% (2)
- D79% (31)
Community Discussion
No community discussion yet for this question.