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?
A. It will influence the gathering of statistics for a table based on the value specified for ESTIMATE_PERCENT provided on table preferences for the same table exist.
B. It will influence dynamic sampling for a query to estimate the statistics based on ESTIMATE_PERCENT.
C. The automatic statistics gathering job running in the maintenance window will use global preferences even if table preferences for the same table exist.
D. New objects created will use global preference even if table preferences are specified.
|
Download Printable PDF. VALID exam to help you PASS. |
 |