Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statement describes the effect of the above command()
- AAutomatic statistics collection is stopped for the CUSTOMERS table.
- BStatistics for the CUSTOMERS table are locked and cannot be overwritten.
- CExisting statistics for the CUSTOMERS table become unusable for the query optimizer.
- DSubsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics.