IBM
C2090-600 · Question #35
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
The correct answer is C. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON. See the full explanation below for the reasoning.
Question
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
Options
- AWhen the registry variable DB2_AUTORECLAIMSPACE=YES
- BAfter termination all the back-end processes using TERMINATE command
- CAfter setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
- DWhen the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation
How the community answered
(37 responses)- A11% (4)
- B5% (2)
- C81% (30)
- D3% (1)
Community Discussion
No community discussion yet for this question.