试题详情
- 单项选择题 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
关注下方微信公众号，在线模考后查看
热门试题
- 在Oracle中引入的（）语句通常被称作
- Evaluate this SQL st
- ou have
- You are
- You execute
- 当创建列表分区时，必须指定（）。
- View this&ensp
- Given： 10. int
- 下列选项中，属于系统全局区（SGA）的是
- You enabled
- Given： Which s
- Given: Whatistheres
- The user Sue issues
- A SELECT statement
- 当需要创建用户时，可以使用如下（）语句来
- Why would&ensp
- Click the
- What methods&#
- Which statemen
- 下列不属于Oracle表空间的是（）。