1Z0-084無料問題集「Oracle Database 19c Performance and Tuning Management」

質問 1

Users complain about slowness and session interruptions. Additional checks reveal the following error in the application log:

Which file has additional information about this error?

（A）SQL trace file automatically generated by the error

（B）ASH report

（C）Session trace file SQL trace file automatically generated by the error

（D）Alert log

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

You use SQL Tuning Advisor to tune a given SQL statement.
The analysis eventually results in the implementation of a SQL Profile.
You then generate the new SQL Profile plan and enforce it using a SQL Plan Baseline but forget to disable the SQL Profile and a few days later you find out that the SQL Profile is generating a new execution plan.
Which two statements are true?

（A）The existence of two concurrent plan stability methods generates a child cursor for every execution.

（B）The execution plan is the one enforced by the SQL Plan Baseline.

（C）The execution plan is the one enforced by the SQL Profile.

（D）The SQL Plan Baseline must be accepted in order to be used for the execution plan.

（E）The SQL Profiles as well as SQL Plan Baseline are implemented using hints, so they both generate the same plan.

（F）The conflict between the two plan stability methods results in an error.

正解：C、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

Which Optimizer component helps decide whether to use a nested loop join or a hash join in an adaptive execution plan?

（A）SQL Plan Directives

（B）Automatic Reoptimization

（C）Dynamic Statistics

（D）Statistics Collector

（E）Statistics Feedback

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

Examine this command:

What is the maximum number of baselines generated by this command that you can have at any given time?

（A）3

（B）5

（C）1

（D）52

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

18. The application provider has given full indications regarding the procedure to collect statistics.
To reduce the space used in the SYSAUX tablespace, you want to prevent the optimizer statistics Advisor from running.
Which method will allow you to do this?

（A）Use DBMS_AUTO_TASK_ADMIN. DISABLE to disable the AUTO_STATS_ADVISOR_TASK task.

（B）Set the parameter OPTIMIZER_ADAPTIVE_STATISTICS to FALSE.

（C）Set the AUTO_STATS_ADVISOR_TASK global statistics preference to FALSE.

（D）Use DBMS STATS.DROP ADVISOR TASK to drop the AUTO_STATS_ADVISOR_TASK task.

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true'

（A）With a target of 700 MB or more, all multipass executions work areas would be eliminated.

（B）GGREGATE_TARGET should be set to at least 700 MB.

（C）With a target of 800 MB or more, all one-pass execution work areas would be eliminated.

（D）PGAA_AGGREGATE should be set to at least 800 MB.

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

1Z0-084 無料問題集「Oracle Database 19c Performance and Tuning Management」

弊社を連絡する

関連リンク

トップ試験