网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

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

参考答案

更多 “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” 相关考题
考题 You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?() A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MBB. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manuallyC. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zeroD. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

考题 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

考题 Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters?() A、 SORT_AREA_SIZEB、 HASH_AREA_SIZEC、 BITMAP_MERGE_AREA_SIZED、 CREATE_BITMAP_AREA_SIZEE、 PGA_AGGREGATE_TARGET

考题 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.

考题 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

考题 When manually configuring the SGA,which of the following parameter changes requires an instance restart to take effect?()   "First Test, First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 ExamA、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE

考题 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

考题 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()A、The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.B、The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.C、The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.D、The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb, respectively

考题 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.

考题 多选题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

考题 多选题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.

考题 单选题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?()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