Which statement describes the effect of the above command?

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

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.
Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

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

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



Leave a Reply 1

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


networkmanagers

networkmanagers

I have the same idea. B