Free Oracle 1z1-084 Exam Dumps Questions & Answers

Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true'

• A.  With a target of 700 MB or more, all multipass executions work areas would be eliminated.
• B.  With a target of 800 MB or more, all one-pass execution work areas would be eliminated.
• C.  GGREGATE_TARGET should be set to at least 700 MB.
• D.  PGAA_AGGREGATE should be set to at least 800 MB.

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.  A 60% cache hit ratio can be observed for database instances which have very good I/O performance.
• B.  The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.
• C.  Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.
• D.  A 99% cache hit ratio can be observed for database instances which have very poor I/O performance.
• E.  The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.

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 the current working directory
• C.  By viewing V$SERV_MOD_ACT_STATS
• D.  In $ORACLE_BASE/diag/rdbms/<db unique name>/<instance name>/trace

A Standard Edition production database has performance problems for two hours on the same day each week.
Which tool must you use to diagnose the problem?

• A.  AWR Compare Periods report
• B.  Statspack report
• C.  Database Replay
• D.  SQL Performance Analyzer

Which three types of statistics are captured by statspack with snap level 6?

• A.  Segment-level statistics
• B.  Parent and child latches
• C.  Parent and child latches
• D.  Plan usage data
• E.  Enqueue statistics
• F.  Optimizer execution plans