Câu 1: C2090-611: DB2 10.1 DBA for Linux UNIX and Windows

The values of the automatic maintenance database configuration parameters for a database named SAMPLE are as follows: What commands must be run to enable real-time statistics collection on the SAMPLE database?

1. A. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;
2. B. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON; — đáp án hiện tại
3. C. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;
4. D. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;