PrepAway - Latest Free Exam Questions & Answers

What commands must be run to enable real-time statistic…

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_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_STMT_STATS ON;

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;

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


Leave a Reply