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

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

多选题

Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）

Allocates memory for RMAN backup and restore operations

Allocates memory for shared and private SQL areas

Contains a cursor area for storing runtime information about cursors

Contains stack space

Contains a hash area performing hash joins of tables

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

多选题Which two statements are true about Shared SQL Area and Private SQL Areas（）AShared SQL Area will be allocated in the shared pool.BShared SQL Area will be allocated when a session starts.CShared SQL Area will be allocated in the large pool always.DThe whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.EShared SQL Area and Private SQL Area will be allocated in the PGA or large pool.FThe number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

点击查看答案
第2题

单选题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）

点击查看答案
第3题

单选题You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）Astreams poolBshared poolClog bufferDkeep buffer cacheErecycle buffer cache

点击查看答案
第4题

多选题Which two statements are true about Shared SQL Area and Private SQL Area（）AShared SQL Area will be allocated in the shared pool.BShared SQL Area will be allocated when a session starts.CShared SQL Area will be allocated in the large pool always.DPrivate SQL Area will be allocated in the Program Global Area （PGA） always.EShared SQL Area and Private SQL Area will be allocated in the PGA or large pool.FThe number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

点击查看答案
第5题

多选题Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）ALOG_BUFFERBSORT_AREA_SIZECJAVA_POOL_SIZEDSTREAMS_POOL_SIZEEDB_16K_CACHE_SZIEFDB_KEEP_CACHE_SIZE

点击查看答案
第6题

单选题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？（）Arecycle buffer cacheBlarge poolCstreams poolDkeep buffer cacheEredo log buffer

点击查看答案
第7题

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

点击查看答案

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

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

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容