Oracle
1Z0-117 · Question #65
1Z0-117 Question #65: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #65. The question stem and answer options stay visible for context.
Question
You are administering a database that supports an OLTP workload. Automatic optimizer statistics collection is scheduled in the night maintenance window. Some of the tables get updated frequently during day time and you notice a performance degradation for queries using those tables due to stale statistics. Which two options might help to avoid the performance degradation of the queries?
Options
- ASet the global statistics preference STALE_PERCENT to 0.
- BUse dynamically sampling hint for the queries on frequently updated tables.
- CCreate histogram for the columns used frequently in the WHERE clause.
- DGather statistics with global statistics preference NO_VALIDATE to TRUE.
- ESet the OPTIMZER_USE_PENDING_STATISTICS parameter to TRUE.
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.