최신 1z1-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

문제2

What are the least elevated values of statistics_level and C0NTR0LJ4ANAGEMENT_PACK_ACCESS that allow the usage of Monitoring of Database Operations?

A. STATISTICS_LEVEL=BASIC and CONTROL_MANAGEMENT_PACK ACCESS=DIAGOSTIC

B. STATISTICS_LEVEL=ALL and
CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC+TUNING

C. STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS-
DIAGOSTIC*TUNING

D. STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC

정답: B

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

문제3

Which two actions can cause invalidation or loss of one or more results in the SQL Query Result Cache?

A. Decreasing the value set for RESULT_CACHE_REMOTE_EXPIRATION.

B. A request was made by the RCBG background process in a physical standby database that is opened read only and whose primary has a result cache.

C. result_cache_max_size is set dynamically to 0.

D. One or more results were aged out of the result cache.

E. A request was made by the RCBG background of a non-RAC database.

정답: C,D

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

문제4

Buffer cache access is too frequent when querying the SALES table. Examine this command which executes successfully:
ALTER TABLE SALES SHRINK SPACE;
For which access method does query performance on sales improve?

A. index range scan

B. db file scattered read

C. index full scan

D. db file sequential read

정답: D

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

문제5

Which two statements are true about session wait information contained in v$session or v$session_wait?

A. Rows for sessions that are not waiting might contain the actual wait time for the last event for which they waited.

B. Rows for sessions displaying WAITED UNKNOWN TIME in the STATE column indicate that the session is still waiting.

C. Rows for sessions that are currently waiting have a wait time of 0.

D. Rows for sessions that are currently waiting have their wait time incremented every microsecond.

E. Rows for sessions that are not waiting always contain the total wait time since the session started.

정답: A,C

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

문제6

Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

A. Re-create the SALES table.

B. Partition the SALES table.

C. Increase PCTFREE for the SALES table.

D. Compress the SALES table.

E. Coalesce all sales table indexes.

정답: B,D

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

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

우리와 연락하기

유용한 링크

최신 업데이트