网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
YouhaveincludedthefollowingparametersettingsinyourSPFILE：SGA_MAX_SIZE=8GSGA_TARGET=6GDB_CACHE_SIZE=2GSHARED_POOL_SIZE=1GLOG_BUFFER=64MDB_KEEP_CACHE_SIZE=960MWhichstatementistrueifyoumodifytheSGA_TARGETinitializationparameter？（）
A.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan8G
B.TheDB_CACHE_SIZEinitializationparametercannotbesettoavaluelessthan2G
C.TheDB_CACHE_SIZEinitializationparametercannotbesettoavaluegreaterthan2G
D.TheDB_KEEP_CACHE_SIZEinitializationparametercannotbesettoavaluegreaterthan960M
E.TheDB_KEEP_CACHE_SIZEinitializationparametercannotbesettoavaluelessthan960M
参考答案
更多 “ YouhaveincludedthefollowingparametersettingsinyourSPFILE：SGA_MAX_SIZE=8GSGA_TARGET=6GDB_CACHE_SIZE=2GSHARED_POOL_SIZE=1GLOG_BUFFER=64MDB_KEEP_CACHE_SIZE=960MWhichstatementistrueifyoumodifytheSGA_TARGETinitializationparameter？（）A.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan8GB.TheDB_CACHE_SIZEinitializationparametercannotbesettoavaluelessthan2GC.TheDB_CACHE_SIZEinitializationparametercannotbesettoavaluegreaterthan2GD.TheDB_KEEP_CACHE_SIZEinitializationparametercannotbesettoavaluegreaterthan960ME.TheDB_KEEP_CACHE_SIZEinitializationparametercannotbesettoavaluelessthan960M ” 相关考题
考题
Inyourrunninginstance，someoftheinitializationparametersaresetasshownbelow：SGA_MAX_SIZE=14GBDB_CACHE_SIZE=1GBSHARED_POOL_SIZE=3GBSTATISTICS_LEVEL=BASICPGA_AGGREGATE_TARGET=0YouplantoenableAutomaticSharedMemoryManagementbutyouarenotabletosetSGA_TARGETtoanonzerovalue.Whatcouldbethereason？（）A.TheSTATISTICS_LEVELinitializationparameterissettoBASICB.ThePGA_AGGREGATE_TARGETinitializationparameterissettozero.C.TheSGA_MAX_SIZEinitializationparameterissettolessthan20GBD.TheDB_CACHE_SIZEinitializationparameterissettolessthan5GBE.TheSHARED_POOL_SIZEinitializationparameterissettoanonzerovalue.
考题
Note the following parameters settings in your database:SGA_MAX_SIZE = 1024MSGA_TARGET = 700MDB_8K_CACHE_SIZE = 124MLOG_BUFFER = 200MYou 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 dynamicallyB. It will be successful only if the memory is available from the auto tuned componentsC. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGETD. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
热门标签
最新试卷