更多“Cache memory的作用是()。 ”相关问题
  • 第1题:

    Which two options describe how MySQL Server allocates memory?()

    A.Thread memory is pre-allocated up to thread_cache_size for performance

    B.Each connection may have its own per-thread memory allocations

    C.Global memory resources are allocated at server startup

    D.Each thread allocates memory from a global pool


    参考答案:B, C

  • 第2题:

    Which of the following is a function of the XceL4 Cache?()

    • A、It places frequently accessed data close to the processor to help deliver faster performance.
    • B、It replaces L3 cache memory.
    • C、It speeds up processor performance by purging the current set of instructions and freeing them up to work on the next set of instructions.
    • D、It allows the system to address more than 16GB of memory.

    正确答案:A

  • 第3题:

    Upgrading which of the following components in a server has the GREATEST affect on virtualization?()

    • A、Amount of Memory
    • B、Number of HBAs
    • C、Hard drive cache size
    • D、ECC ability in memory

    正确答案:A

  • 第4题:

    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

  • 第5题:

    计算机内的存储器呈现出一种层次结构的形式,即()三层结构。

    • A、Cache-Memory-disk
    • B、Memory-Cache-disk
    • C、CPU-Cache-disk
    • D、CPU-Cache-Memory

    正确答案:A

  • 第6题:

    单选题
    Which of the following defines memory interleaving?()
    A

     The distribution of data written across all the memory DIMMs and the L1 cache

    B

     The distribution of data written across all the memory DIMMs in one bank

    C

     The distribution of data written across all the memory DIMMs and the processor

    D

     The distribution of data written across all the memory DIMMs and the L2 cache


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

  • 第7题:

    单选题
    Records from the data dictionary information are stored in which of the following database memory areas?()
    A

    Library cache 

    B

    Row cache 

    C

    Session UGA 

    D

    Buffer cache


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

  • 第8题:

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

  • 第9题:

    单选题
    Cache memory的作用是()。
    A

    提高数据访问速度

    B

    增加程序可用内存的大小

    C

    在可不丢失数据的内存中存储数据

    D

    为操作系统内核增加可用的内存容量


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

  • 第10题:

    单选题
    Automatic Shared Memory Management (ASMM) has been enabled for your database instance.  Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;  Which statement is true in this scenario()
    A

    The minimum memory size for the database buffer cache is set to 100 mb.

    B

    The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb

    C

    The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.

    D

    The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb


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

  • 第11题:

    单选题
    计算机内的存储器呈现出一种层次结构的形式,即()三层结构。
    A

    Cache-Memory-disk

    B

    Memory-Cache-disk

    C

    CPU-Cache-disk

    D

    CPU-Cache-Memory


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

  • 第12题:

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

  • 第13题:

    Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=0PGA_AGGREGATE_TARGET=500mWhich 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


    参考答案:A, E, F

  • 第14题:

    Which of the following defines memory interleaving?()

    • A、The distribution of data written across all the memory DIMMs and the L1 cache
    • B、The distribution of data written across all the memory DIMMs in one bank
    • C、The distribution of data written across all the memory DIMMs and the processor
    • D、The distribution of data written across all the memory DIMMs and the L2 cache

    正确答案:B

  • 第15题:

    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()

    • A、Library cache 
    • B、Row cache
    • C、Dictionary cache 
    • D、Large area 
    • E、Buffer cache

    正确答案:B

  • 第16题:

    Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY, what is its effect? ()

    • A、The Advisory is on and will capture both CPU and memory overhead.
    • B、The Advisory is on but the memory for the Advisory is not allocated.
    • C、The Advisory is off and the memory for the Advisory is not allocated.
    • D、The Advisory is off but the memory for the Advisory remains allocated.

    正确答案:D

  • 第17题:

    Cache memory的作用是()。

    • A、提高数据访问速度
    • B、增加程序可用内存的大小
    • C、在可不丢失数据的内存中存储数据
    • D、为操作系统内核增加可用的内存容量

    正确答案:A

  • 第18题:

    单选题
    Which of the following is a function of the XceL4 Cache?()
    A

    It places frequently accessed data close to the processor to help deliver faster performance.

    B

    It replaces L3 cache memory.

    C

    It speeds up processor performance by purging the current set of instructions and freeing them up to work on the next set of instructions.

    D

    It allows the system to address more than 16GB of memory.


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

  • 第19题:

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

  • 第20题:

    单选题
    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()
    A

    Library cache 

    B

    Row cache

    C

    Dictionary cache 

    D

    Large area 

    E

    Buffer cache


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

  • 第21题:

    单选题
    You create an Oracle 10g database and configure the SPFILE as follows:   SGA_TARGET=2G   DB_CACHE_SIZE=512M  LOG_BUFFER=50M   DB_KEEP_CACHE_SIZE=128M   You modify the SGA_TARGET initialization parameter using the following statement:   SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH;   Which entity does this statement affect?()
    A

     only the auto-tuned memory components

    B

     only the memory components that are not auto-tuned

    C

     both the auto-tuned memory components and the non-auto-tuned memory components

    D

     neither the auto-tuned memory components nor the non-auto-tuned memory components


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

  • 第22题:

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

  • 第23题:

    单选题
    The SPFILE for the PROD database specifies the following initialization parameter values:   SGA_TARGET = 2G   DB_8K_CACHE_SIZE = 128M   You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay, you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M:   SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH;   What is the result of this statement?()
    A

     The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.

    B

     The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.

    C

     The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.

    D

     The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.


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

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