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

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

相似考题

1.A senior DBA asked you to execute the following command to improve performance:SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?（）A. The keep pool is not configured.B. Automatic Workarea Management is not configured.C. Automatic Shared Memory Management is not enabled.D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

2.在SQL语句执行前的解析阶段,要判断其中涉及的表名和列名是否合法,判断所依据的信息存放在()A.PGAB.SHARED POOLC.DATABASE BUFFER CACHED.REDO LOG BUFFER CACHEE.LARGE POOL

3. In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？  A、 database buffer cacheB、 shared poolC、 PGAD、 large pool

4.An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.How would you guarantee that the blocks for the table never age out?（）A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.B. Increase the database buffer cache size.C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.D. Configure Automata Shared Memory Management.E. Configure Automatic Memory Management

更多“单选题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”相关问题

  • 第1题：

    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

    正确答案:B

  • 第2题：

    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

    正确答案:B

  • 第3题：

    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

  • 第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题：

    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

  • 第6题：

    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

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     SQL Tuning Advisor

    D

     SQL Access Advisor

    E

     Automatic Database Diagnostic Monitor （ADDM）


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

  • 第9题：

    单选题
    A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）
    A

    The keep pool is not configured.

    B

    Automatic Workarea Management is not configured.

    C

    Automatic Shared Memory Management is not enabled.

    D

    The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

    E

    All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view


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

  • 第10题：

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


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

  • 第11题：

    单选题
    Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）
    A

    Java pool

    B

    Large pool

    C

    Shared pool

    D

    Streams pool

    E

    Library cache

    F

    Redo log buffer

    G

    Data dictionary cache

    H

    Database buffer cache


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

  • 第12题：

    多选题
    You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）
    A

    log buffer

    B

    Java pool

    C

    Large pool

    D

    Fixed SGA

    E

    Shared pool

    F

    Streams pool

    G

    Keep buffer cache

    H

    Database buffer cache


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

  • 第13题：

    在SQL语句执行前的解析阶段，要判断其中涉及的表名和列名是否合法，判断所依据的信息存放在（）

    • A、PGA
    • B、SHARED POOL
    • C、DATABASE BUFFER CACHE
    • D、REDO LOG BUFFER CACHE
    • E、LARGE POOL

    正确答案:B

  • 第14题：

    The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.

    • A、large pool
    • B、shared pool
    • C、data buffer cache
    • D、redo log buffer
    • E、data dictionary cache

    正确答案:D

  • 第15题：

    A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）

    • A、The keep pool is not configured.
    • B、Automatic Workarea Management is not configured.
    • C、Automatic Shared Memory Management is not enabled.
    • D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
    • E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

    正确答案:D

  • 第16题：

    You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）

    • A、 log buffer
    • B、 Java pool
    • C、 Large pool
    • D、 Fixed SGA
    • E、 Shared pool
    • F、 Streams pool
    • G、 Keep buffer cache
    • H、 Database buffer cache

    正确答案:B,C,E,H

  • 第17题：

    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

  • 第18题：

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


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

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第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）


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？
    A

     database buffer cache

    B

     shared pool

    C

     PGA

    D

     large pool


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

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）
    A

    Configure the KEEP buffer pool and alter the table with the corresponding storage clause.

    B

    Increase the database buffer cache size.

    C

    Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.

    D

    Configure Automata Shared Memory Management.

    E

    Configure Automatic Memory Management


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

相关内容