Oracle
1Z0-117 · Question #68
1Z0-117 Question #68: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.
Question
You are administering a database that supports an OLTP workload in which one of the applications inserts rows in a table until 12 noon every, after which multiple years perform frequent queries on the table. You want the statistics to be more representative of the table population. What must be done to ensure that an optimizer uses the latest statistics of the table?
Options
- ASet the STALE_PERCENT preference to 0.
- BSet the OPTIMIZER_MODE parameter to ALL_ROWS.
- CSet the OPTIMIZER_DYNAMIC_SAMPLING parameter to 0.
- DUse the FIRST_ROWS_n hint in the queries.
- EUnlock and gather statistics for the table after inserts are done and lock them again.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 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.