Oracle
1Z0-117 · Question #116
1Z0-117 Question #116: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #116. The question stem and answer options stay visible for context.
Question
You are administering a database that supports an OLTP application. To set statistics preferences, you issued the following command: SQL > DBMS_STATS.SET_GLOBAL_PREFS (
ESTIMATE_PERCENT', 9'); What will be the effect of executing this procedure?Options
- AIt will influence the gathering of statistics for a table based on the value specified for ESTIMATE_PERCENT
- BIt will influence dynamic sampling for a query to estimate the statistics based on ESTIMATE_PERCENT.
- CThe automatic statistics gathering job running in the maintenance window will use global preferences even
- DNew objects created will use global preference even if table preferences are specified.
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.