Oracle
1Z0-064 · Question #84
1Z0-064 Question #84: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #84. The question stem and answer options stay visible for context.
Question
You want to generate statistics for new objects added to an OLTP application without affecting old statistics and the sessions that currently use them. Which two tasks would you perform to test the new statistics? (Choose two.)
Options
- ASet the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to TRUE for the
- BSet the STALE_PERCENT statistics preference to zero and then gather statistics.
- CSet the PUBLISH statistics preference to FALSE and then gather statistics.
- DUse the DBMS_STATS.PUBLISH_PENDING_STATS procedure to make pending statistics the
- ESet the NO_INVALIDATE statistics preference to FALSE and gather statistics without affecting
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.