1Z0-084 무료 덤프문제 온라인 액세스

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

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

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 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.
• 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 Statspack and import it by using $ORACLE_HOME/rdbms/admin
  /awrload into the AWR repository.
• D.Export the data by using expdp from the ftatspack repository and import it by using impdp into the AWR repository.

Examine this statement and output:

Which two situations can trigger this error?

• A.There is a file in the capture directory.
• B.The instance is unable to access the capture directory.
• C.The capture directory is part of the root file system.
• D.The user lacks the required privileges to execute the DBMS WORKLOAD CAPTURE package or the directory.
• E.The syntax is incomplete.

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 when CPU time exceeds 1 minute for each user call.
• C.A warning alert will be issued only when CPU time exceeds 10000 microseconds for each user call.
• D.A critical alert will be issued when CPU time exceeds 10000 microseconds for each user call.

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

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