欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2023-11-02 13:29:16
2、Which two are true about Optimizer Statistics? ❑ A) They do not persist across Instance restarts. ❑ B) They are automatically updated when DDL state ......

2、Which two are true about Optimizer Statistics?


❑ A) They do not persist across Instance restarts.

❑ 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