Oracle
1Z0-064 · Question #1
1Z0-064 Question #1: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #1. The question stem and answer options stay visible for context.
Question
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.)
Options
- ASet the STALE_PERCENT statistic preference to a higher value than the default, and then gather
- BSet the STATISTICS_LEVEL parameter to ALL for the instance.
- CSet the INCREMENTAL preference to TRUE, and then gather statistics.
- DSet the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE for the session in which
- ESet the PUBLISH statistic preference to FALSE, and then gather statistics.
- FSet the NO_INVALIDATE statistic preference to TRUE, and then gather statistics.
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.