Question 2
You are administering a database that supports an OLTP workload. Users complain about the degraded response time of a query. You want to gather new statistics for objects accessed by the query and test query performance with the new statistics without affecting other sessions connected to the instance.
The STALE_PERCENT statistic preference is set to a default value and the STATISTICS_LEVEL parameter is set to TYPICAL.
Which two actions would you take to accomplish the task? (Choose two.)
Set the STALE_PERCENT statistic preference to a higher value than the default, and then gather statistics.
Set the STATISTICS_LEVEL parameter to ALL for the instance.
Set the INCREMENTAL preference to TRUE, and then gather statistics.
Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE for the session in which you want to test the query.
Set the PUBLISH statistic preference to FALSE, and then gather statistics.
Set the NO_INVALIDATE statistic preference to TRUE, and then gather statistics.
Correct answer: BE