多选题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?（）
A

Allocates memory for RMAN backup and restore operations

B

Allocates memory for shared and private SQL areas

C

Contains a cursor area for storing runtime information about cursors

D

Contains stack space

E

Contains a hash area performing hash joins of tables

相似考题

1.You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()A. User session dataB. Stack spaceC. Private SQL areaD. Location of the runtime area for DML and DDL StatementsE. Location of a part of the runtime area for SELECT statements

2.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

3.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

4.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

参考答案和解析
正确答案： B,E
解析： 暂无解析
更多“多选题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题：

    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 operations
    • B、Allocates memory for shared and private SQL areas
    • C、Contains a cursor area for storing runtime information about cursors
    • D、Contains stack space
    • E、Contains a hash area performing hash joins of tables

    正确答案:A,B,C

  • 第2题：

    The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

    • A、 LOG_BUFFER
    • B、 DB_CACHE_SIZE
    • C、 JAVA_POOL_SIZE
    • D、 LARGE_POOL_SIZE
    • E、 SHARED_POOL_SIZE
    • F、 STREAMS_POOL_SIZE

    正确答案:A,F

  • 第3题：

    Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.  What would be your next step to improve performance？ （）

    • A、Run the SQL Access Advisor.
    • B、Run the Memory Advisor for the sga.
    • C、Run the Memory Advisor for the pga.
    • D、Run the Memory Advisor for the shared pool.
    • E、Run the Memory Advisor for the buffer cache.

    正确答案:D

  • 第4题：

    You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）

    • A、Configure Java Pool to cache the java objects.
    • B、Configure Streams Pool to enable parallel processing.
    • C、Increase Shared Pool size to cache more PL/SQL objects.
    • D、Increase Database Buffer Cache size to increase cache hits.
    • E、Configure Large Pool to be used by RMAN and shared server.
    • F、Increase the total System Global Area （SGA） size to increase memory hits.

    正确答案:E

  • 第5题：

    Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）

    • A、large pool
    • B、streams pool
    • C、keep buffer cache
    • D、recycle buffer cache

    正确答案:A

  • 第6题：

    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

    正确答案:A

  • 第7题：

    Which two statements are true about Shared SQL Area and Private SQL Areas（）

    • A、Shared SQL Area will be allocated in the shared pool.
    • B、Shared SQL Area will be allocated when a session starts.
    • C、Shared SQL Area will be allocated in the large pool always.
    • D、The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.
    • E、Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
    • F、The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

    正确答案:A,F

  • 第8题：

    多选题
    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)?（）
    A

    LOG_BUFFER

    B

    SORT_AREA_SIZE

    C

    JAVA_POOL_SIZE

    D

    STREAMS_POOL_SIZE

    E

    DB_16K_CACHE_SZIE

    F

    DB_KEEP_CACHE_SIZE


    正确答案： D,C
    解析： 暂无解析

  • 第9题：

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


    正确答案： D
    解析： 暂无解析

  • 第10题：

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

    B

    Redo Log Buffer

    C

    Database Buffer Cache

    D

    Program Global Area （PGA）


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    Which two statements are true about Shared SQL Area and Private SQL Area（）
    A

    Shared SQL Area will be allocated in the shared pool.

    B

    Shared SQL Area will be allocated when a session starts.

    C

    Shared SQL Area will be allocated in the large pool always.

    D

    Private SQL Area will be allocated in the Program Global Area （PGA） always.

    E

    Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.

    F

    The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.


    正确答案： E,A
    解析： 暂无解析

  • 第12题：

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


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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 Pool
    • B、Redo Log Buffer
    • C、Database Buffer Cache
    • D、Program Global Area （PGA）

    正确答案:A

  • 第14题：

    Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.  What would be your next step to improve performance（）

    • A、Run the SQL Access Advisor.
    • B、Run the Memory Advisor for the sga
    • C、Run the Memory Advisor for the pga.
    • D、Run the Memory Advisor for the shared pool.
    • E、Run the Memory Advisor for the buffer cache

    正确答案:D

  • 第15题：

    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

    正确答案:A,B,C,D

  • 第16题：

    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 Pool
    • B、Redo Log Buffer
    • C、Database Buffer Cache
    • D、Program Global Area （PGA）

    正确答案:A

  • 第17题：

    Which two statements are true about Shared SQL Area and Private SQL Area（）

    • A、Shared SQL Area will be allocated in the shared pool.
    • B、Shared SQL Area will be allocated when a session starts.
    • C、Shared SQL Area will be allocated in the large pool always.
    • D、Private SQL Area will be allocated in the Program Global Area （PGA） always.
    • E、Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
    • F、The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

    正确答案:A,F

  • 第18题：

    You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.  Which action would you consider to overcome the performance degradation？（）

    • A、Configure Java Pool to cache the java objects.
    • B、Configure Streams Pool to enable parallel processing.
    • C、Increase Shared Pool size to cache more PL/SQL objects.
    • D、Increase Database Buffer Cache size to increase cache hits.
    • E、Configure Large Pool to be used by RMAN and shared server.
    • F、Increase the total System Global Area （SGA） size to increase memory hits.

    正确答案:E

  • 第19题：

    多选题
    You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）
    A

    User session data

    B

    Stack space

    C

    Private SQL area

    D

    Location of the runtime area for DML and DDL Statements

    E

    Location of a part of the runtime area for SELECT statements


    正确答案： B,D
    解析： 暂无解析

  • 第20题：

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

    B

    Redo Log Buffer

    C

    Database Buffer Cache

    D

    Program Global Area （PGA）


    正确答案： A
    解析： 暂无解析

  • 第21题：

    多选题
    Which two statements are true about Shared SQL Area and Private SQL Areas（）
    A

    Shared SQL Area will be allocated in the shared pool.

    B

    Shared SQL Area will be allocated when a session starts.

    C

    Shared SQL Area will be allocated in the large pool always.

    D

    The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.

    E

    Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.

    F

    The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.


    正确答案： D,B
    解析： 暂无解析

  • 第22题：

    单选题
    You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）
    A

     streams pool

    B

     shared pool

    C

     log buffer

    D

     keep buffer cache

    E

     recycle buffer cache


    正确答案： E
    解析： 暂无解析

  • 第23题：

    多选题
    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)?（）
    A

    LOG_BUFFER

    B

    SORT_AREA_SIZE

    C

    JAVA_POOL_SIZE

    D

    STREAMS_POOL_SIZE

    E

    DB_16K_CACHE_SZIE

    F

    DB_KEEP_CACHE_SIZE


    正确答案： B,A
    解析： 暂无解析

  • 第24题：

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

    B

    Allocates memory for shared and private SQL areas

    C

    Contains a cursor area for storing runtime information about cursors

    D

    Contains stack space

    E

    Contains a hash area performing hash joins of tables


    正确答案： E,C
    解析： 暂无解析

相关内容