What two statements are true regarding the recommendations received from the SQL Access
Advisor? (Choose two.)
A.
It can recommend partitioning only on tables that have at least 10,000 rows
B.
It cannot generate recommendations that support multiple workload queries
C.
It can recommend only B-tree indexes and not bitmap or function-based indexes
D.
It can recommend partitioning on table provided that the workloads have some predicates and
joins on the columns of the NUMBER or DATE type