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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |