최신 1Z0-084 무료덤프 - Oracle Database 19c Performance and Tuning Management

문제1

Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance?

A. Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.

B. A 60% cache hit ratio can be observed for database instances which have very good I/O performance.

C. The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.

D. A 99% cache hit ratio can be observed for database instances which have very poor I/O performance.

E. The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.

정답: D,E

설명: (DumpTOP 회원만 볼 수 있음)

문제2

Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance?

A. Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.

B. A 60% cache hit ratio can be observed for database instances which have very good I/O performance.

C. The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.

D. A 99% cache hit ratio can be observed for database instances which have very poor I/O performance.

E. The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.

정답: D,E

문제3

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. Set the parameter OPTIMIZER_ADAPTIVE_STATISTICS to FALSE.

B. Set the AUTO_STATS_ADVISOR_TASK global statistics preference to FALSE.

C. Use DBMS_AUTO_TASK_ADMIN. DISABLE to disable the AUTO_STATS_ADVISOR_TASK task.

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

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제4

Examine these commands, which execute successfully:

Which statement is true?

A. AWR snapshots can be purged manually in pluggable databases.

B. AWR- snapshots in all pluggable databases will be purged automatically after every 60 mins.

C. ADDM, AWR, and ASH reports can be purged automatically.

D. AD DM is enabled for all pluggable databases.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제5

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

A. When the I/O is less than 10% of the DB time

B. When the buffer cache and library cache hit ratio is above 95%

C. When the tuning goal has been met

D. When all the concurrency waits are eliminated from the Top 10

E. When the allocated budget for performance tuning has been exhausted

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제6

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

A. Automatic Reoptimization

B. Dynamic Statistics

C. Statistics Feedback

D. Statistics Collector

E. SQL Plan Directives

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

최신 1Z0-084 무료덤프 - Oracle Database 19c Performance and Tuning Management

우리와 연락하기

유용한 링크

최신 업데이트