Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.
(Choose two.)
A.
Cursor cache
B.
Stored outline
C.
SQL Tuning Set
D.
Automatic Workload Repository (AWR) snapshots
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.(Choose two.)
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.
(Choose two.)
Why not D?
I think the AWR can recommend SQL plans but requires DBA intervention to load into baselines.
awr is option as well however you would use awr as source to load sqls in sql tuning set first; therefore ‘direct’ sources to load sqls are sql tuning set and cursor cache only.