网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）
A
recycle buffer cache
B
large pool
C
streams pool
D
keep buffer cache
E
redo log buffer
参考答案
参考解析
解析：
暂无解析
更多 “单选题You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）A recycle buffer cacheB large poolC streams poolD keep buffer cacheE redo log buffer” 相关考题
考题
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 three are true about the large pool for an Oracle database instance that supports shared serverconnections?()
A. Allocates memory for RMAN backup and restore operationsB. Allocates memory for shared and private SQL areasC. Contains a cursor area for storing runtime information about cursorsD. Contains stack spaceE. Contains a hash area performing hash joins of tables
考题
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）A、 recycle buffer cacheB、 large poolC、 streams poolD、 keep buffer cacheE、 redo log buffer
考题
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
考题
You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A、 streams poolB、 shared poolC、 log bufferD、 keep buffer cacheE、 recycle buffer cache
考题
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）A、Allocates memory for RMAN backup and restore operationsB、Allocates memory for shared and private SQL areasC、Contains a cursor area for storing runtime information about cursorsD、Contains stack spaceE、Contains a hash area performing hash joins of tables
考题
Identify the memory component from which memory may be allocated for: （） 1: Session memory for the shared server 2: Buffers for I/O slaves 3: Oracle Database Recovery Manager (RMAN) backup and restore operations A、Large PoolB、Redo Log BufferC、Database Buffer CacheD、Program Global Area （PGA）
考题
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
考题
You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）A、The trace fileB、The fixed viewsC、The data dictionary viewsD、The operating system log fieldsE、The dynamic performance views.
考题
You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）A、Library cache B、Row cacheC、Dictionary cache D、Large area E、Buffer cache
考题
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
考题
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
考题
Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operationsA、Large PoolB、Redo Log BufferC、Database Buffer CacheD、Program Global Area （PGA）
考题
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.
考题
单选题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 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.
考题
多选题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
考题
单选题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 configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A
streams poolB
shared poolC
log bufferD
keep buffer cacheE
recycle buffer cache
考题
单选题You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）A
The trace fileB
The fixed viewsC
The data dictionary viewsD
The operating system log fieldsE
The dynamic performance views.
考题
单选题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.
考题
单选题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 three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for storing runtime information about cursorsDContains stack spaceEContains a hash area performing hash joins of tables
热门标签
最新试卷