网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Your SPFILE contains the following parameter settings： SGA_TARGET = 8G DB_CACHE_SIZE = 4G SHARED_POOL_SIZE = 2G LARGE_POOL_SIZE = 512M JAVA_POOL_SIZE = 512M LOG_BUFFER = 100M SGA_MAX_SIZE = 10G You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement： SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH； What is the result of this statement？（）
A
The database crashes.
B
The large pool releases 512M of memory.
C
The large pool retains 1G of allocated memory.
D
The large pool increases to 1，512M of memory.
参考答案
参考解析
解析：
暂无解析
更多 “单选题Your SPFILE contains the following parameter settings： SGA_TARGET = 8G DB_CACHE_SIZE = 4G SHARED_POOL_SIZE = 2G LARGE_POOL_SIZE = 512M JAVA_POOL_SIZE = 512M LOG_BUFFER = 100M SGA_MAX_SIZE = 10G You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement： SQLALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH； What is the result of this statement？（）A The database crashes.B The large pool releases 512M of memory.C The large pool retains 1G of allocated memory.D The large pool increases to 1，512M of memory.” 相关考题
考题
YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement：SQLSELECTname，value，isdefault2FROMv$parameter3WHEREnameLIKE’%size%’；TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply？（）A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1GB.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1GC.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGAD.ThevaluesoftheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscannotbesetmanually.E.NominimumlimitsareimposedontheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameters.F.TheAutomaticSharedMemoryManagementfeaturecannotbedisabledunlessyouspecifyvaluesfortheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparametersintheinitializationparameterfile.
考题
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:SQL startupORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.Identify the reason the instance failed to start.（）A.The PGA_AGGREGATE_TARGET parameter is set to zero.B.The STATISTICS_LEVEL parameter is setto basic.C.Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.D.The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
考题
Which two statements are true regarding the SGA_TARGET initialization parameter（）A、It can be increased up to the value of the SGA_MAX_SIZE parameter.B、Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.C、Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.D、Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
考题
Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）A、 set SHARED_POOL_SIZE to zeroB、 set STATISTICS_LEVEL to BASICC、 set SGA_TARGET to a non-zero valueD、 set DB_CACHE_SIZE to a non-zero valueE、 set STATISTICS_LEVEL to TYPICAL or ALL
考题
In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）A、The STATISTICS_LEVEL initialization parameter is set to BASICB、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GBD、The DB_CACHE_SIZE initialization parameter is set to less than 5 GBE、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
考题
Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A、The command succeeds only if Automatic Memory Management is not enabled.B、The command succeeds， but you need to restart the database for changes to take effect.C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.D、The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.
考题
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
考题
You create an Oracle 10g database and configure the SPFILE as follows： SGA_TARGET=2G DB_CACHE_SIZE=512M LOG_BUFFER=50M DB_KEEP_CACHE_SIZE=128M You modify the SGA_TARGET initialization parameter using the following statement： SQLALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH； Which entity does this statement affect？（） A、 only the auto-tuned memory componentsB、 only the memory components that are not auto-tunedC、 both the auto-tuned memory components and the non-auto-tuned memory componentsD、 neither the auto-tuned memory components nor the non-auto-tuned memory components
考题
The SPFILE for your database contains the following parameter settings： SGA_TARGET = 1000M DB_CACHE_SIZE = 512M SHARED_POOL_SIZE = 128M LOG_BUFFER = 10M DB_8K_CACHE_SIZE = 50M What is the total memory that can be distributed across the auto-tuned memory components？（） A、 940MB、 990MC、 690MD、 1000M
考题
Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH； What would be the outcome of this command？ （）A、The command would return an error because LOG_BUFFER is a static parameter.B、The parameter value would be changed and it would come into effect immediately.C、You need to restart the database so that parameter changes can come into effect.D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
考题
Your SPFILE contains the following parameter settings： SGA_TARGET = 8G DB_CACHE_SIZE = 4G SHARED_POOL_SIZE = 2G LARGE_POOL_SIZE = 512M JAVA_POOL_SIZE = 512M LOG_BUFFER = 100M SGA_MAX_SIZE = 10G You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement： SQLALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH； What is the result of this statement？（） A、 The database crashes.B、 The large pool releases 512M of memory.C、 The large pool retains 1G of allocated memory.D、 The large pool increases to 1，512M of memory.
考题
You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE:// SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）A、 Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.B、 Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.C、 Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.D、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.E、 Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool component to the desired size by reallocating the additional memory from the auto-tuned memory components.F、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.
考题
Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）A、 The parameter DB_CACHE_SIZE must be a multiple of 8.B、 The value of the parameter SGA_MAX_SIZE must be increased.C、 The tablespace must be created with a uniform extent size of 8 KBD、 The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
考题
You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）A、 only the INSTANCE_TYPE initialization parameter is set to an invalid valueB、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
考题
单选题Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A
The command succeeds only if Automatic Memory Management is not enabled.B
The command succeeds， but you need to restart the database for changes to take effect.C
The command returns an error because the size of the redo log buffer cannot be changed dynamically.D
The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.
考题
多选题You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement： SQL SELECT name， value， isdefault 2 FROM v$parameter 3 WHERE name LIKE ’%size%’； The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply？（）AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters.FThe Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.
考题
单选题Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command？（）A
The command would return an error because LOG_BUFFER is a static parameter.B
The parameter value would be changed and it would come into effect immediately.C
You need to restart the database so that parameter changes can come into effect.D
The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
考题
单选题The SPFILE for your database contains the following parameter settings： SGA_TARGET = 1000M DB_CACHE_SIZE = 512M SHARED_POOL_SIZE = 128M LOG_BUFFER = 10M DB_8K_CACHE_SIZE = 50M What is the total memory that can be distributed across the auto-tuned memory components？（）A
940MB
990MC
690MD
1000M
考题
单选题You have included the following parameter settings in your SPFILE:// SGA_MAX_SIZE=8G SGA_TARGET=6G DB_CACHE_SIZE=2G SHARED_POOL_SIZE=1G LOG_BUFFER=64M DB_KEEP_CACHE_SIZE=960M Which statement is true if you modify the SGA_TARGET initialization parameter？（）A
The SGA_TARGET initialization parameter cannot be set to a value greater than 8GB
The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2GC
The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2GD
The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M E
The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M
考题
单选题You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）A
only the INSTANCE_TYPE initialization parameter is set to an invalid valueB
only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC
only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD
both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
考题
单选题Your SPFILE contains the following parameter settings： SGA_TARGET = 8G DB_CACHE_SIZE = 4G SHARED_POOL_SIZE = 2G LARGE_POOL_SIZE = 512M JAVA_POOL_SIZE = 512M LOG_BUFFER = 100M SGA_MAX_SIZE = 10G You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement： SQLALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH； What is the result of this statement？（）A
The database crashes.B
The large pool releases 512M of memory.C
The large pool retains 1G of allocated memory.D
The large pool increases to 1，512M of memory.
考题
单选题You create an Oracle 10g database and configure the SPFILE as follows： SGA_TARGET=2G DB_CACHE_SIZE=512M LOG_BUFFER=50M DB_KEEP_CACHE_SIZE=128M You modify the SGA_TARGET initialization parameter using the following statement： SQLALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH； Which entity does this statement affect？（）A
only the auto-tuned memory componentsB
only the memory components that are not auto-tunedC
both the auto-tuned memory components and the non-auto-tuned memory componentsD
neither the auto-tuned memory components nor the non-auto-tuned memory components
考题
多选题Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）Aset SHARED_POOL_SIZE to zeroBset STATISTICS_LEVEL to BASICCset SGA_TARGET to a non-zero valueDset DB_CACHE_SIZE to a non-zero valueEset STATISTICS_LEVEL to TYPICAL or ALL
考题
单选题To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.（）A
The PGA_AGGREGATE_TARGET parameter is set to zero.B
The STATISTICS_LEVEL parameter is setto basic.C
Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.D
The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
考题
单选题You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A
Query the V$FLASHBACK_DATABASE_LOG view.B
Query the V$FLASHBACK_DATABASE_STAT view.C
Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D
Query the V$RECOVERY_FILE_DEST view.
考题
单选题In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）A
The STATISTICS_LEVEL initialization parameter is set to BASICB
The PGA_AGGREGATE_TARGET initialization parameter is set to zero.C
The SGA_MAX_SIZE initialization parameter is set to less than 20 GBD
The DB_CACHE_SIZE initialization parameter is set to less than 5 GBE
The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
考题
单选题Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）A
The parameter DB_CACHE_SIZE must be a multiple of 8.B
The value of the parameter SGA_MAX_SIZE must be increased.C
The tablespace must be created with a uniform extent size of 8 KBD
The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
热门标签
最新试卷
