Prev Question
Next Question

Examine the following command:
SQL> DBMS_STATS. SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);
What is the effect of executing this command?

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

B.
Automatic statistics collection is stopped for the CUSTOMERS table.

C.
Statistics for the CUSTOMERS table are locked and cannot be overwritten.

D.
Statistics subsequently gathered on the CUSTOMERS table are stored as pending statistics.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *