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

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

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

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*TUNING
• C.STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC
• D.STATISTICS_LEVEL=ALL and
  CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC+TUNING

Database performance has degraded recently.
index range scan operations on index ix_sales_time_id are slower due to an increase in buffer gets on sales table blocks.
Examine these attributes displayed by querying DBA_TABLES:

Now, examine these attributes displayed by querying DBA_INDEXES:

Which action will reduce the excessive buffer gets?

• A.Re-create the SALES table using the columns in IX_SALES_TIME_ID as the hash partitioning key.
• B.Partition index IX_SALES_TIME_ID using hash partitioning.
• C.Re-create index IX_SALES_TIME_ID using ADVANCED COMPRESSION.
• D.Re-create the SALES table sorted in order of index IX_SALES_TIME_ID.

Which two Oracle Database features use database services?

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

Which three statements are true about server-generated alerts?

• A.They may contain suggestions for correcting the identified problems.
• B.They are logged in the alert log.
• C.They provide notifications but never any suggestions for correcting the identified problems.
• D.They can be viewed only from the Cloud Control Database home page.
• E.They are notifications from the Oracle Database Server of an existing or impending problem.
• F.Their threshold settings can be modified by using DBMS_SERVER_ALERT.