Examinethecommand:SQL>DBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand()
A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.
B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.
C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.
D.Subsequently,statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics.