多选题You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：  SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario？ （）AA total

题目
多选题
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：  SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario？ （）
A

A total of 14 GB memory will be allocated to the automatically tuned memory components

B

Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB

C

The value for SGA_TARGET can be increased up to a maximum of 14 GB

D

A maximum of 3 GB can be allocated to shared pool

E

Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters

F

Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE

相似考题

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.You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）A、 The database must be in the ARCHIVELOG mode.B、 The automatic memory tuning must be enabled.C、 The change tracking feature must be enabled.D、 The automatic memory tuning must be disabled.

3.Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components？（）A、PMONB、SMONC、MMNLD、MMANE、MMON

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

参考答案和解析
正确答案： F,E
解析： 暂无解析
更多“You enabled Automatic Shared Memory Management. The initiali”相关问题

  • 第1题：

    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 Central
    • B、 Global Attributes
    • C、 Resource Monitors
    • D、 Memory Parameters
    • E、 Database Usage Statistics
    • F、 All Initialization Parameters
    • G、 Automatic Workload Repository

    正确答案:A,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题：

    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

  • 第4题：

    In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）  

    • A、 Setting a nonzero value for SGA_TARGET
    • B、 Configuring Automatic Shared Memory Management
    • C、 Configuring Automatic Memory Management
    • D、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
    • E、 None of the above

    正确答案:B

  • 第5题：

    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

  • 第6题：

    单选题
    Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components？（）
    A

    PMON

    B

    SMON

    C

    MMNL

    D

    MMAN

    E

    MMON


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

  • 第7题：

    单选题
    In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）
    A

     Setting a nonzero value for SGA_TARGET

    B

     Configuring Automatic Shared Memory Management

    C

     Configuring Automatic Memory Management

    D

     Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

    E

     None of the above


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

  • 第8题：

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

    B

    Global Attributes

    C

    Resource Monitors

    D

    Memory Parameters

    E

    Database Usage Statistics

    F

    All Initialization Parameters

    G

    Automatic Workload Repository


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

  • 第9题：

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

     MMAN

    B

     PMON

    C

     MMON

    D

     MMNL


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

  • 第10题：

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


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

  • 第11题：

    多选题
    You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：  SGA_TARGET= 10GB  SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario？ （）
    A

    A maximum of 3 GB can be allocated to shared pool

    B

    The value for SGA_TARGET can be increased up to a maximum of 15 GB

    C

    A total of 14 GB memory will be allocated to the automatically tuned memory components.

    D

    Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE

    E

    Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters

    F

    Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB


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

  • 第12题：

    单选题
    Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）
    A

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


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

  • 第13题：

    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

  • 第14题：

    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第15题：

    Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第16题：

    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？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:C

  • 第17题：

    单选题
    You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）
    A

     The database must be in the ARCHIVELOG mode.

    B

     The automatic memory tuning must be enabled.

    C

     The change tracking feature must be enabled.

    D

     The automatic memory tuning must be disabled.


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

  • 第18题：

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


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

  • 第19题：

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


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

  • 第20题：

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

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


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

  • 第21题：

    多选题
    Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）
    A

    set SHARED_POOL_SIZE to zero

    B

    set STATISTICS_LEVEL to BASIC

    C

    set SGA_TARGET to a non-zero value

    D

    set DB_CACHE_SIZE to a non-zero value

    E

    set STATISTICS_LEVEL to TYPICAL or ALL


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

  • 第22题：

    单选题
    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）
    A

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


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

  • 第23题：

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


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

  • 第24题：

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

相关内容