• Description:DB2 9 Database Administrator for Linux UNIX and Windows Upgrade
• Passing Score:0%
• Practice Test - Number of questions:53 questions
• Simulation Test - Number of questions:53 questions
• Simulation Test Duration:120 minutes
• Has explanations:No

Answer(s)

1. database administrator wishes to enable automatic maintenance so that the performance ofcomplex queries might be improved through the use of automatic statistical profile generation.Which parameters within the Database Configuration file must be set to ON in order for automaticstatistical profile generation to be enabled?A. AUTO_MAINT, AUTO_TBL_MAINT, AUTO_RUNSTATS
2. AUTO_MAINT, AUTO_TBL_MAINT, AUTO_STATS_PROF
3. AUTO_MAINT, AUTO_RUNSTATS, AUTO_STATS_PROF
4. AUTO_TBL_MAINT, AUTO_RUNSTATS, AUTO_STATS_PROF

AUTO_MAINT, AUTO_TBL_MAINT, AUTO_STATS_PROF