【OCP|052】OCP最新题库解析系列-2
程序员文章站
2022-06-02 10:59:17
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