In which three situations can dynamic statistics be used? (Choose three.)
A.
when the sampling time is a small fraction of the total time for a query
B.
when an execution plan is suboptimal because of complex predicates
C.
when extended statistics are not available for SQL statements that use complex predicates
D.
when a query is on a partitioned table with a global index
E.
when index statistics are missing on a column that is used in SQL statements with highly selective filters
Explanation:
https://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL341