Online Access Free 1Z0-084 Practice Test

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.Trace Analyzer and Tracsess
• C.Autotrace and TKPROF
• D.TKPROF and Trace Analyzer

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

• A.Both SGA_TARGET and SGA_MAX_SIZE must be set to zero.
• B.All auto-tuned SGA components are reset to their original user-defined values.
• C.It requires a database instance restart to take effect.
• D.All SGA components retain their current sizes at the time of disabling.
• E.The SGA size remains unaffected after disabling ASMM.
• F.All SGA components excluding fixed SGA and other internal allocations are readjusted immediately after disabling ASMM.

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.Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 25
• C.Setting PARALLEL_DEGREE_POLICYADAPTIVE
• D.Setting DB_KEEP_CACHE_SIZE to at least 50M
• E.Increasing DB_CACHESIZE to 1 G
• F.Setting PARALLEL_DEGREE_POLICYAUTO

What are the least elevated values of statistics_level and C0NTR0LJ4ANAGEMENT_PACK_ACCESS that allow the usage of Monitoring of Database Operations?

• A.STATISTICS_LEVEL=BASIC and CONTROL_MANAGEMENT_PACK ACCESS=DIAGOSTIC
• B.STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC
• C.STATISTICS_LEVEL=ALL and
  CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC+TUNING
• D.STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS-
  DIAGOSTIC*TUNING

Which two Oracle Database features use database services?

• A.Oracle SQL Tuning Advisor
• B.Oracle Scheduler
• C.Oracle SQL Performance Management
• D.Oracle Automatic Reoptimization
• E.Database Resource Manager