1Z0-084 試験問題を無料オンラインアクセス

You execute the following:
EXECUTE DBMS_AuTO_TASK_ADMIN.DISABLE;
Which advisor remains enabled?

• A.Automatic Segment Advisor
• B.Automatic SQL Tuning
• C.Optimizer Statistics Advisor
• D.SQL Plan Management Evolve Advisor
• E.Automatic Optimizer Statistics Collection

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 buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.
• B.Both the RECYCLE and KEEP buffer caches should always have a very high 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 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 transport performance data from a Standard Edition to an Enterprise Edition database. What is the recommended method to do this?

• A.Export the data by using expdp from Statspack and import it by using $ORACLE_HOME/rdbms/admin
  /awrload into the AWR repository.
• B.Export the data by using the exp utility and parameter file spuexp.par from the Statspack repository and import it by using imp into a dedicated Statspack schema on the destination.
• C.Export the data by using expdp from the ftatspack repository and import it by using impdp into the AWR repository.
• D.Export the data by using the expdp utility and parameter file spuexp.par from the Statspack repository and import it by using impdp into Export the data by using expdp from the Statspack repository and import it by using impdp into the AWR repository.

Examine this code block, which executes successfully:
DBMS_SERVER_ALERT. SET_THRESHOLD (
DBMS_SERVER_ALERT.CPU_TIME_PER_CALL, DBMS_SERVER_ALERT. OPERATOR_GE, '8000', DBMS_SERVER_ALERT.OPERATOR_GE, '10000', 1, 2, 'inst1', DBMS_SERVER_ALERT.OBJECT_TYPE_SERVICE, 'main.regress.rdbms.dev.us.example.com') ;

What will happen?

• A.A critical alert will be issued when CPU time exceeds 2 minutes for each user call.
• B.A warning alert will be issued only when CPU time exceeds 10000 microseconds for each user call.
• C.A warning alert will be issued when CPU time exceeds 1 minute for each user call.
• D.A critical alert will be issued when CPU time exceeds 10000 microseconds for each user call.

Which two Oracle Database features use database services?

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