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

문제1

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

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

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

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

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

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

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

정답: B,C,D

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

문제2

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 회원만 볼 수 있음)

문제3

Which two statements are true about disabling Automatic Shared Memory Management (ASMM)?

A. All SGA components retain their current sizes at the time of disabling.

B. All auto-tuned SGA components are reset to their original user-defined values.

C. The SGA size remains unaffected after disabling ASMM.

D. It requires a database instance restart to take effect.

E. All SGA components excluding fixed SGA and other internal allocations are readjusted immediately after disabling ASMM.

F. Both SGA_TARGET and SGA_MAX_SIZE must be set to zero.

정답: A,C

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

문제4

Database performance has degraded recently.
index range scan operations on index ix_sales_time_id are slower due to an increase in buffer gets on sales table blocks.
Examine these attributes displayed by querying DBA_TABLES:

Now, examine these attributes displayed by querying DBA_INDEXES:

Which action will reduce the excessive buffer gets?

A. Re-create the SALES table sorted in order of index IX_SALES_TIME_ID.

B. Re-create index IX_SALES_TIME_ID using ADVANCED COMPRESSION.

C. Partition index IX_SALES_TIME_ID using hash partitioning.

D. Re-create the SALES table using the columns in IX_SALES_TIME_ID as the hash partitioning key.

정답: B

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

문제5

You must write a statement that returns the ten most recent sales. Examine this statement:

Users complain that the query executes too slowly. Examine the statement's current execution plan:

What must you do to reduce the execution time and why?

A. Replace the FETCH FIRST clause with ROWNUM to enable the use of an index on SALES.

B. Enable Adaptive Plans so that Oracle can change the Join method as well as the Join order for this query.

C. Create an index on SALES.CUST_ID to force an INDEX RANGE SCAN on this index followed by a NESTED LOOP join between CUSTOMERS and SALES.

D. Collect a new set of statistics on PRODUCT, CUSTOMERS, and SALES because the current stats are inaccurate.

E. Create an index on SALES.TIME_ID to force the return of rows in the order specified by the ORDER BY clause.

정답: E

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

문제6

Examine this statement and output:

Which three statements are true?

A. Session 8779 may be waiting for a user or application response.

B. Session 9857 waited 1354 seconds for another process, which was also waiting for a transaction to end.

C. Both 9822 and 8779 sessions are waiting for operating system resources.

D. Session 9822 will always stop waiting if the session that owns the TX enqueue issues a COMMIT statement as session 9822 is the first session in the transaction queue.

E. Session 9857 is not waiting.

F. Session 8779 may be waiting due to a network problem.

정답: A,D,F

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

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

우리와 연락하기

유용한 링크

최신 업데이트