1z1-084試験無料問題集（57題）「Oracle Database 19c Performance and Tuning Management 認定」

出題：1

An Oracle 19c database uses default values for all optimizer initialization parameters.
After a table undergoes partition maintenance, a large number of wait events occur for:
cursor: pin S wait on X
Which command reduces the number of these wait events?

A. ALTER SYSTEM SET SESSION CACHED CURSORS = 500;

B. ALTER SYSTEM SET CURSOR_SHARING = FORCE;

C. ALTER SYSTEM SET CURSOR_SPACE_FOR_TIME - TRUE;

D. ALTER SYSTEM SET CURSOR_INVALIDATION = DEFERRED;

正解：D 解答を投票する

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

出題：2

Which procedure gathers statistics that are always used in the generation of any execution plan?

A. DBMS_STATS.GATHER_FIXED_ OBJECTS_STATS

B. DBMS_STATS.GATHER_SYSTEM_STATS

C. DBMS_STATS.GATHER_DATABASE_STATS

D. DBMS_STATS.GATHER_DICTIONARY_STATS

正解：C 解答を投票する

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

出題：3

You execute the following:
EXECUTE DBMS_AuTO_TASK_ADMIN.DISABLE;
Which advisor remains enabled?

A. Optimizer Statistics Advisor

B. Automatic SQL Tuning

C. Automatic Optimizer Statistics Collection

D. Automatic Segment Advisor

E. SQL Plan Management Evolve Advisor

正解：C 解答を投票する

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

出題：4

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. The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.

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

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

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

正解：C,E 解答を投票する

出題：5

Examine this statement and output:

Which two situations can trigger this error?

A. The user lacks the required privileges to execute the DBMS WORKLOAD CAPTURE package or the directory.

B. The instance is unable to access the capture directory.

C. There is a file in the capture directory.

D. The capture directory is part of the root file system.

E. The syntax is incomplete.

正解：A,B 解答を投票する

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

出題：6

Which two types of performance problems are reported by ADDM for PDBS?

A. SGA sizing issues

B. User I/O waits

C. I/O capacity limits

D. Top SQL statements

E. Excessive checkpoint writes

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

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

1z1-084試験無料問題集「Oracle Database 19c Performance and Tuning Management 認定」