---

Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）；  Which statementdescribes the effect of the above command（）
A:Automatic statistics collection is stopped for the CUSTOMERS table.
B:Statistics for the CUSTOMERS table are locked and cannot be overwritten.
C:Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
D:Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics

---

出自：Oracle认证

显示答案