Which two are true about Optimizer Statistics? (Choose two.)
A. They are automatically updated when DDL statements execute
B. They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package
C. They are gathered by the Manageability Monitor (MMON) background process
D. They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements
E. They can be used to determine the events on which a database instance waited
F. They do not persist across instance restarts
|
Download Printable PDF. VALID exam to help you PASS. |
 |