多选题To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE
多选题
To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）
A
DB_CACHE_SIZE
B
SHARED_POOL_SIZE
C
LARGE_POOL_SIZE
D
JAVA_POOL_SIZE
E
SGA_MAX_SIZE
F
SORT_AREA_SIZE
参考解析
解析：
暂无解析
相关考题：
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?（）A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC. The database instance starts, but Automatic Memory Management is disabledD. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（） A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE
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.
You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true？（）A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC、 The database instance starts，but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control
Which statement about Automatic Memory Management with Oracle 11g is true？（） A、 You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B、 Oracle can reallocate memory between the SGA and PGA automatically as needed.C、 To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D、 You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？ （）A、 A maximum of 3 GB can be allocated to shared poolB、 The value for SGA_TARGET can be increased up to a maximum of 15 GBC、 A total of 14 GB memory will be allocated to the automatically tuned memory components.D、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZEE、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parametersF、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page？（） A、 Advisor CentralB、 Global AttributesC、 Resource MonitorsD、 Memory ParametersE、 Database Usage StatisticsF、 All Initialization ParametersG、 Automatic Workload Repository
Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）A、The SGA advisor will be disabled.B、The MTTR advisor will be disabled.C、Automatic checkpoint tuning will be disabled.D、Checkpoint information will not be written to the alert log file.
To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE
For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
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 tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） A、 Generate reports on data failure such as data file failures.B、 You can track the Service Request （SR） and implement repairs.C、 You can package and upload diagnostic data to Oracle Support.D、 You can manually run health checks to gather diagnostic data for a problem.
多选题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.
多选题Which two statements are true regarding the SGA_TARGET initialization parameter（）AIt can be increased up to the value of the SGA_MAX_SIZE parameter.BIncreasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.CReducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.DIncreasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
多选题You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted（）AThe MEMORY_MAX_TARGET parameter is automatically set to 500 mb.BThe pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.CThe value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.DThe lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb， respectively
多选题You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page？（）AAdvisor CentralBGlobal AttributesCResource MonitorsDMemory ParametersEDatabase Usage StatisticsFAll Initialization ParametersGAutomatic Workload Repository
单选题The SPFILE for the PROD database specifies the following initialization parameter values： SGA_TARGET = 2G DB_8K_CACHE_SIZE = 128M You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay， you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M： SQLALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH； What is the result of this statement？（）A The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.B The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.C The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.D The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.
单选题Which statement about Automatic Memory Management with Oracle 11g is true？（）A You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B Oracle can reallocate memory between the SGA and PGA automatically as needed.C To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
多选题Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（）ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE
多选题Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（）ASORT_AREA_SIZEBHASH_AREA_SIZECBITMAP_MERGE_AREA_SIZEDCREATE_BITMAP_AREA_SIZEEPGA_AGGREGATE_TARGET
多选题Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）AThe SGA advisor will be disabled.BThe MTTR advisor will be disabled.CAutomatic checkpoint tuning will be disabled.DCheckpoint information will not be written to the alert log file.
多选题You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）AApplication Server ControlBOracle Management ServiceCOracle Enterprise Manager RepositoryDOracle Enterprise Manager Database Control
单选题For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above
单选题Which statement about Automatic Memory Management with Oracle 11g is true?（）AYou cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.BOracle can reallocate memory between the SGA and PGA automatically as needed.CTo use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.DYou can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size
多选题You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？ （）AA maximum of 3 GB can be allocated to shared poolBThe value for SGA_TARGET can be increased up to a maximum of 15 GBCA total of 14 GB memory will be allocated to the automatically tuned memory components.DIncreasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZEEIncreasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parametersFReducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB