Oracle
1Z0-054 · Question #30
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 =>…
The correct answer is A. It generates execution plans and execution statistics. B. It executes only the query part of the DML statements. See the full explanation below for the reasoning.
Question
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.)
Options
- AIt generates execution plans and execution statistics.
- BIt executes only the query part of the DML statements.
- CThe test plans are generated and added to plan baseline.
- DThe test plans are executed, but not generated if they are available in the plan baseline.
How the community answered
(29 responses)- A72% (21)
- C7% (2)
- D21% (6)
Community Discussion
No community discussion yet for this question.