多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题