Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statement describes 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.
正确答案:D
答案解析:有

微信扫一扫手机做题