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.
A is right. for TEST_EXECUTE method, it generates the plan and run and collect execution stats
B is right. by default, it only execute the query part of DML statement.
C is wrong. no adding into sql plan baseline
D is wrong. plan generated.
So A.B. are correct