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.
Oracle can reallocate memory between the SGA and PGA automatically as needed.
To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
第1题:
A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
第2题:
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?()
第3题:
Which statement about Automatic Memory Management with Oracle 11g is true?()
第4题:
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
第5题:
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()
第6题:
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?()
第7题:
The SGA_TARGET initialization parameter cannot be set to a value less than 1G
The SGA_TARGET initialization parameter cannot be set to a value greater than 1G
The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA
The values of the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters cannot be set manually.
No minimum limits are imposed on the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters.
The 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.
第8题:
MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
MEMORY_TARGET is static and cannot be modified without shutting down the instance
第9题:
Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
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
第10题:
Automatic PGA Memory Management
Automatic SGA Memory Management
Automatic Shared Memory Management
Automatic Memory Management
Manual SGA Memory Management
None of the above
第11题:
The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
The database instance starts, but Automatic Memory Management is disabled
The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
第12题:
Automatic PGA Memory Management
Automatic SGA Memory Management
Automatic Shared Memory Management
Automatic Memory Management
Manual SGA Memory Management
None of the above
第13题:
Which statements about the MEMORY_TARGET initialization parameter are true?()
第14题:
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?()
第15题:
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?()
第16题:
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?()
第17题:
Which statement about Automatic Memory Management with Oracle 11g is true?()
第18题:
Set MEMORY_TARGET to zero
Set the STATISTICS_LEVEL parameter to BASIC
Set the WORKAREA_SIZE_POLICY parameter to MANUAL
Set the PGA_AGGREGATE_TARGET parameter to nonzero value
第19题:
MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
MEMORY_TARGET is static and cannot be modified without shutting down the instance
第20题:
The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
The database instance starts, but Automatic Memory Management is disabled
The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
第21题:
The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
第22题:
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.
Oracle can reallocate memory between the SGA and PGA automatically as needed.
To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
第23题:
Set MEMORY_TARGET to zero
Set the STATISTICS_LEVEL parameter to BASIC
Set the WORKAREA_SIZE_POLICY parameter to MANUAL
Set the PGA_AGGREGATE_TARGET parameter to nonzero value
第24题:
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.
Oracle can reallocate memory between the SGA and PGA automatically as needed.
To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size