Examine the command:

Examine the command:SQL>DBMS_STATS.SET_TABLE_PREFS(‘SH’,’CUSTOMERS’,’PUBLISH’,’false’); Which statement describes the effect of the above command?

Question:

Examine the command:

Options:

Automatic statistics collection is stopped for the CUSTOMERS table

Statistics for the CUSTOMERS table are locked and cannot be overwritten

Existing statistics for the CUSTOMERS table become unusable for the query optimizer

Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

Correct Answer

The Correct Answer for this Question is

Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics