网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()
A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
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.
考题
Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)
A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
考题
You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components？（） A、 MMANB、 PMONC、 MMOND、 MMNL
考题
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
考题
Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）A、As ASM instance mounts an ASM control fileB、An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components？（）A、PMONB、SMONC、MMNLD、MMANE、MMON
考题
Which statement is true about the Manageability Monitor （MMON） background proces（）A、It transfers statistics from memory to disk at regular intervals.B、It coordinates the rebalance activity for disk groups when ASM is used.C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.
考题
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
考题
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）A、 log bufferB、 Java poolC、 Large poolD、 Fixed SGAE、 Shared poolF、 Streams poolG、 Keep buffer cacheH、 Database buffer cache
考题
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
考题
In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（） A、 Setting a nonzero value for SGA_TARGETB、 Configuring Automatic Shared Memory ManagementC、 Configuring Automatic Memory ManagementD、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE、 None of the above
考题
By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（） 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 background process does Automatic Shared Memory Management use to coordinate the sizing of memory components？（）A
PMONB
SMONC
MMNLD
MMANE
MMON
考题
单选题In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）A
Setting a nonzero value for SGA_TARGETB
Configuring Automatic Shared Memory ManagementC
Configuring Automatic Memory ManagementD
Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE
None of the above
考题
单选题Examine the parameter setting in your database: Which statement is correct about the database?（）A
Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not setB
The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are setC
The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are setD
Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
考题
多选题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
考题
单选题You have included the following parameter setting in your server parameter file： PGA_AGGREGATE_TARGET = 800M SORT_AREA_SIZE = 100M HASH_AREA_SIZE = 100M BITMAP_MERGE_AREA_SIZE = 100M CREATE_BITMAP_AREA_SIZE = 100M Which statement is true？（）A
All the *_AREA_SIZE parameters are ignored.B
The Automatic PGA Memory Management feature cannot be disabled.C
The total Program Global Area （PGA） memory cannot be manually increased above 800M.D
The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.
考题
单选题By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（）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 are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components？（）A
MMANB
PMONC
MMOND
MMNL
考题
单选题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 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 are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？（）AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
考题
单选题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 is true about the Manageability Monitor （MMON） background process（）A
It transfers statistics from memory to disk at regular intervals.B
It coordinates the rebalance activity for disk groups when ASM is used.C
It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.D
It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
考题
单选题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 have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）Alog bufferBJava poolCLarge poolDFixed SGAEShared poolFStreams poolGKeep buffer cacheHDatabase buffer cache
热门标签
最新试卷
