多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题