最新Oracle Database 19c 1z1-084考試題庫，Oracle 1z1-084課程的擬真試題下載

問題1
Database performance degraded between 23:15 and 23:30 for the last three nights. The awr snapshot interval is one hour. The AODM report contains nothing about this performance problem.
With which tool can you further analyze this problem?

A. AWR Compare Periods report

B. Active Session History report

C. SQL Tuning Advisor

D. SQL Performance Analyzer

正確答案: B

說明：（僅 NewDumps 成員可見）

問題2
You need to collect and aggregate statistics for the ACCTG service and PAYROLL module, and execute:

Where do you find the output of this command?

A. By viewing V$SERVICE_STATS

B. In $ORACLE_BASE/diag/rdbms/<db unique name>/<instance name>/trace

C. By viewing V$SERV_MOD_ACT_STATS

D. In the current working directory

正確答案: C

說明：（僅 NewDumps 成員可見）

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

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

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

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

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

正確答案: B,D

問題4
You must produce a consolidated formatted trace file by combining all trace files generated by all clients for a single service.
Which combination of utilities does this?

A. Trcsess and TKPROF

B. Autotrace and TKPROF

C. Trace Analyzer and Tracsess

D. TKPROF and Trace Analyzer

正確答案: A

說明：（僅 NewDumps 成員可見）

問題5
SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_target is then set to a nonzero value but memory_MAX_TARGET is not set.
Which two statements are true?

A.