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

相关问题推荐

• 下列选项中不符合良好程序设计风格的是()。

  A．源程序要文档化

  B．数据说明的次序要规范化

  C．避免滥用goto语句

  D．模块设计要保证高耦合、高内聚

  查看答案

• In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）

  A

   The parallel degree limit for DB_GRP will be the minimum of all the incoming values.

  B

   The parallel degree limit for DB_GRP will be the maximum of all the incoming values.

  C

   The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.

  D

   If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.

  E

   Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

  查看答案

• You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）

  A、 Oracle Enterprise Manager

  B、 The V$LOG view

  C、 The V$LOGFILE view

  D、 The V$FLASHBACK_DATABASE_LOGS view

  查看答案

• 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

  查看答案

• 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

  查看答案