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.
Statistics for the CUSTOMERS table are locked and cannot be overwritten

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

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



Leave a Reply 1

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


jg

jg

13.5.1 Pending Statistics

https://docs.oracle.com/cd/E11882_01/server.112/e41573/stats.htm#PFGRF94751

“Starting with Oracle Database 11g Release 2 (11.2), you have the following options when gathering statistics:

Publish the statistics automatically at the end of the gather operation (default behavior)

Save the new statistics saved as pending

Saving the new statistics as pending allows you to validate the new statistics and publish them only if they are satisfactory. “