Oracle
1Z0-083 · Question #209
1Z0-083 Question #209: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #209. The question stem and answer options stay visible for context.
Question
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)
Options
- AThe number of table rows is considered when evaluating the cost of accessing a table using
- BIndex balanced B*Tree height is considered when evaluating the cost of using an index.
- CThe Statistics Advisor can help recommend the best way to gather statistics.
- DStatistics collected using DBMS_STATS always yield the best optimizer result.
- EThe Statistics Advisor generates actions for all recommendations.
Unlock 1Z0-083 to see the answer
You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 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.