2、Which two are true about Optimizer Statistics?


❑ A) They do not persist across Instance restarts.

SRE实战 互联网时代守护先锋,助力企业售后服务体系运筹帷幄!一键直达领取阿里云限量特价优惠。

❑ B) They are automatically updated when DDL statements execute.

❑ C) They are gathered by the Manageability Monitor (MMON) background process.

❑ D) They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package.

❑ E) They can be used to determine the events on which a database instance waited.

❑ F) They provide Information to the Optimizer so that it can determine optimal execution plans for SQL statements.


• Answer:DF

 【OCP|052】OCP最新题库解析系列-2 Oracle

扫码关注我们
微信号:SRE实战
拒绝背锅 运筹帷幄