You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

A、 Memory Advisor

B、 Segment Advisor

C、 SQL Access Advisor

D、 Automatic Workload Repository （AWR）

E、 Automatic Database Diagnostic Monitor （ADDM）

相关问题推荐

• You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）

  A、 DB_RECOVERY_FILE_DEST only

  B、 DB_FLASHBACK_RETENTION_TARGET only

  C、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only

  D、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only

  E、 DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and

  F、 DB_FLASHBACK_RETENTION_TARGET

  查看答案

• You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

  A、 mount the new disk group in the ASM instance

  B、 restart the ASM instance and the production database instance

  C、 register the new disk groups in the production database instance

  D、 restart the ASM instance without restarting the production database instance

  E、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

  查看答案

• The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

  A

   LOG_BUFFER

  B

   DB_CACHE_SIZE

  C

   JAVA_POOL_SIZE

  D

   LARGE_POOL_SIZE

  E

   SHARED_POOL_SIZE

  F

   STREAMS_POOL_SIZE

  查看答案

• You execute the following command to create two consumer groups， FIN_GROUP1 and PAY_GROUP1 for a plan， PROD_PLAN：  BEGIN  DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （SIMPLE_PLAN =>’prod_plan’，  CONSUMER_GROUP1 => ’fin_group1’，  GROUP1_CPU => 80，  CONSUMER_GROUP2 => ’pay_group1’，  GROUP2_CPU => 20）；  END；  Which three statements are true？ （）

  A

   SYS_GROUP gets 100% CPU resources at level 1.

  B

   FIN_GROUP1 gets 80% CPU resources at level 1.

  C

   FIN_GROUP1 gets 80% CPU resources at level 2.

  D

   PAY_GROUP1 gets 20% CPU resources at level 1.

  E

   PAY_GROUP1 gets 20% CPU resources at level 2.

  F

   OTHER_GROUP gets 100% CPU resources at level 1.

  G

   OTHER_GROUP gets 100% CPU resources at level 2.

  查看答案

• Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

  A

   Backup of offline tablespaces.

  B

   Backup of read-only tablespaces.

  C

   Backup of system-critical tablespaces.

  D

   Backup of online， locally managed tablespaces.

  E

   Backup of read/write dictionary-managed tablespaces.

  查看答案