Oracle
1Z0-417 · Question #75
1Z0-417 Question #75: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-417 to reveal the answer and full explanation for question #75. The question stem and answer options stay visible for context.
Question
Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database. Which would you configure for that to occur?
Options
- ASet OPTIMIZER_USE_PENDING_STATISTICS to TRUE.
- BSet AUTO_UPDATE_STATISTICS to FALSE.
- CUse a HOLD HINT in the SQL.
- DSet AUTOMATIC_WORKLOAD_REPOSITORY_COLLECTION to PAUSE.
Unlock 1Z0-417 to see the answer
You've previewed enough free 1Z0-417 questions. Unlock 1Z0-417 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.