PrepAway - Latest Free Exam Questions & Answers

What commands must be run to enable real-time statistics collection on the SAMPLE database?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
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;

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_STATS_VIEWS ON;

C.
UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON; UPDATE DB CFG FOR
sample USING AUTO_STMT_STATS ON;

D.
UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON; UPDATE DB CFG FOR
sample USING AUTO_STATS_VIEWS ON;


Leave a Reply