Examine the following block that executes a SQL Performance Analyzer task:
begin
dbms_sqlpa.execute_analysis_task(task_name => ‘SPA_SKD4’, execution_type => ‘TEST EXECUTE’, execution_name => ‘before’);
end;
Which two statements are true about the execution? (Choose two.)
A.
It generates execution plans and execution statistics.
B.
It executes only the query part of the DML statements.
C.
The test plans are generated and added to plan baseline.
D.
The test plans are executed, but not generated if they are available in the plan baseline.