---

Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）
A:Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
B:Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
C:Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
D:Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
E:Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

---

出自：Oracle认证

显示答案