1Z0-084試験無料問題集（57題）「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. 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 解答を投票する

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

出題：2

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

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

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

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

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

正解：D 解答を投票する

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

出題：3

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

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

B. Decreasing the value set for RESULT_CACHE_REMOTE_EXPIRATION.

C. 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.

D. result_cache_max_size is set dynamically to 0.

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

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

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

出題：4

Which three statements are true about tuning dimensions and details of v$sys_time_model and DB time?

A. Statspack cannot account for high CPU time when CPU TIME is a Top 10 event in DB time. When CPU time is high, SQL tuning may improve performance.

B. Parse Time Elapsed accounts for successful soft and hard parse operations only.

C. DB Time accounts for all time used by background processes and user sessions.

D. The proportion of WAIT TIME to CPU TIME always increases with increased system load.

E. Systems in which CPU time is dominant need more tuning that those in which WAIT TIME is dominant.

F. When WAIT TIME is high, instance tuning may improve performance.

正解：A,C,F 解答を投票する

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

出題：5

A database instance is suffering poor I/O performance on two frequently accessed large tables.
No Big Table caching occurs in the database.
Examine these parameter settings:

Which are two actions either one of which will allow Big Table caching to occur?

A. Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50

B. Setting PARALLEL_DEGREE_POLICYAUTO

C. Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 25

D. Setting PARALLEL_DEGREE_POLICYADAPTIVE

E. Increasing DB_CACHESIZE to 1 G

F. Setting DB_KEEP_CACHE_SIZE to at least 50M

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

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

出題：6

Which two options are part of a Soft Parse operation?

A. Shared Pool Memory Allocation

B. SQL Row Source Generation

C. Semantic Check

D. SQL Optimization

E. Syntax Check

正解：C 解答を投票する

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

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