试题详情
单项选择题 Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）；  Which statementdescribes 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

  • D

  • 关注下方微信公众号，在线模考后查看

热门试题