Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）

A、It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically

B、It will be successful only if the memory is available from the auto tuned components

C、It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET

D、It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

相关问题推荐

• You issued the following command to mount the DATA disk group in restricted mode：   ALTER DISKGROUP data MOUNT RESTRICT；   What is the implication of this command？（）

  A、 The client RDBMS instance can access the file as a read-only file.

  B、 A new disk cannot be added to a disk group.

  C、 A disk in a disk group can be taken offline.

  D、 The client RDBMS instance cannot access the files in the disk group.

  查看答案

• Identify two situations in which you can use Data Recovery Advisor for recovery.（） 

  A

   The user has dropped an important table that needs to be recovered.

  B

   The database files are corrupted when the database is open.

  C

   You are not able to start up the database instance because the required database files are missing.

  D

   The archived log files are missing for which backup is not available.

  查看答案

• What happens when you run the SQL Tuning Advisor with limited scope？（）  

  A、 Access path analysis is not performed for SQL statements.

  B、 SQL structure analysis is not performed for SQL statements.

  C、 SQL Profile recommendations are not generated for SQL statements.

  D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

  查看答案

• What is the purpose of the catalog command？（）  

  A、 To review RMAN control file and recovery catalog metadata and ensure that its correct

  B、 To delete RMAN backup-related metadata from the recovery catalog

  C、 To create metadata in the control file and the recovery catalog related to backup set pieces 

  D、 To create a report that lists database backups

  E、 To rebuild the recovery catalog

  查看答案

• “TCPSYNFlooding”建立大量处于半连接状态的TCP连接，其攻击目标是网络的(43)。

  A．保密性

  B．完整性

  C．真实性。

  D．可用性

  查看答案