You create an Oracle 12c database and then import schemas that are required by an application which has not
yet been developed.
You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these
schemas.
What must you run to achieve this?
A.
SQL Access Advisor with a SQL tuning set
B.
Automatic Database Diagnostic Monitor (ADDM) report
C.
SQL Tuning Advisor
D.
SQL Access Advisor with a hypothetical workload
E.
SQL Performance Analyzer
D