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

質問 1

You need to collect and aggregate statistics for the ACCTG service and PAYROLL module, and execute:

Where do you find the output of this command?

（A）In the current working directory

（B）By viewing V$SERVICE_STATS

（C）In $ORACLE_BASE/diag/rdbms/<db unique name>/<instance name>/trace

（D）By viewing V$SERV_MOD_ACT_STATS

正解：D 解答を投票する

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

質問 2

You manage a 19c database with default optimizer settings.
This statement is used extensively as subquery in the application queries:
SELECT city_id FROM sh2.sales WHERE city_id=:Bl
You notice the performance of these queries is often poor and, therefore, execute:
SELECT city_id,COUNT(*) FROM sh2.sales GROUP BY city_id;
Examine the results:

There is no index on the CITY_ID column.
Which two options improve the performance?

（A）Force the subquery to use dynamic sampling.

（B）Activate the adaptive plans.

（C）Create an index on the CITY IP column.

（D）Generate frequency histograms on the CITY__ID column.

（E）Use a SQL Profile to enforce the appropriate plan.

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

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

質問 3

Which three types of statistics are captured by statspack with snap level 6?

（A）Enqueue statistics

（B）Segment-level statistics

（C）Plan usage data

（D）Optimizer execution plans

（E）Parent and child latches

（F）Parent and child latches

正解：A、B、F 解答を投票する

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

質問 4

What is the right time to stop tuning an Oracle database?

（A）When the buffer cache and library cache hit ratio is above 95%

（B）When the tuning goal has been met

（C）When the allocated budget for performance tuning has been exhausted

（D）When all the concurrency waits are eliminated from the Top 10

（E）When the I/O is less than 10% of the DB time

正解：B 解答を投票する

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

質問 5

A Standard Edition production database has performance problems for two hours on the same day each week.
Which tool must you use to diagnose the problem?

（A）SQL Performance Analyzer

（B）AWR Compare Periods report

（C）Database Replay

（D）Statspack report

正解：D 解答を投票する

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

質問 6

You must configure and enable Database Smart Flash Cache for a database.
You configure these flash devices:

Examine these parameter settings:

What must be configured so that the database uses these devices for the Database Smart Flash Cache?

（A）Set DB_FLASH_CACHE_SIZE parameter to 128G, 64G.

（B）Disable Automatic Memory Management and set SGA_TARGET to 256G.

（C）Set DB_FLASH_CACHE_SIZE to 192G and MEMORY_TARGET to 256G.

（D）Set DB_FLASH_CACHE_SIZE parameter to 192G.

（E）Set DB_FLASH_CACHE_SIZE to 256G and change device /dev/sdk to 128G.

正解：A 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験