Examine the parameters for your database instance: Exhibit: Which three statements are
true about the process of automatic optimization by using statistics feedback?
A.
After the optimizer identifies a query as a re-optimization candidate, statistics collected by
the collectors are submitted to the optimizer.
B.
The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn
statistics are enabled.
C.
The optimizer enables monitoring for cardinality feedback after the first execution of a
query.
D.
The optimizer automatically changes a plan during subsequent execution of a SQL
statement if there is a huge difference in optimizer estimates and execution statistics.
E.
The optimizer can re optimize a query only once using cardinality feedback.
Explanation:
ACD