参考答案和解析
正确答案: B
解析: 暂无解析
更多“Which background process does Automatic Shared Memory Manage”相关问题
  • 第1题:

    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

    正确答案:A

  • 第2题:

    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

    正确答案:D

  • 第3题:

    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

  • 第4题:

    You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95 Which background process is responsible for issuing alerts when the threshold is crossed()

    • A、System monitor (SMON)
    • B、Process monitor (PMON)
    • C、Memory manager process (MMAN)
    • D、Manageability Monitor process (MMON)

    正确答案:D

  • 第5题:

    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

  • 第6题:

    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

  • 第7题:

    You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (%): 90  Critical (%): 95  Which background process is responsible for issuing alerts when the threshold is crossed()

    • A、System monitor (SMON)
    • B、Process monitor (PMON)
    • C、Memory manager process (MMAN)
    • D、Manageability Monitor process (MMON)

    正确答案:D

  • 第8题:

    单选题
    Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()
    A

     ASMB

    B

     PMON

    C

     RBAL

    D

     SMON


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

  • 第9题:

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

  • 第10题:

    单选题
    As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?()
    A

    CKPT

    B

    SMON

    C

    MMON

    D

    DBWR


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

  • 第11题:

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

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

    Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()

    • A、As ASM instance mounts an ASM control file
    • B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group
    • C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
    • D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

    正确答案:C,D

  • 第14题:

    Which statement is true about the Manageability Monitor (MMON) background proces()

    • 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 databaseinstance.
    • D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

    正确答案:A

  • 第15题:

    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

  • 第16题:

    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

  • 第17题:

    Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?()

    • A、ASMB
    • B、PMON
    • C、RBAL
    • D、SMON

    正确答案:A

  • 第18题:

    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

  • 第19题:

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

  • 第20题:

    单选题
    Which statement is true about the Manageability Monitor (MMON) background proces()
    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 databaseinstance.

    D

    It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.


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

  • 第21题:

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

  • 第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 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
    解析: 暂无解析