Oracle
1Z0-054 · Question #30
1Z0-054 Question #30: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #30. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.