niusouti.com

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

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

相似考题

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

2. Which Coherence caching pattern matches the sequence of events ？（）  1. Data is requested from cache  2. The requested data does not exist in the cache （cache miss）  3. The Coherence cache store is used to red data from the back-end persistent data source， and placed in ther cache  4. Data requested from the cache is returned to the callerA、 read throughB、 write throughC、 refresh aheadD、 write behind

3.A database application is installed on a server. The AIX default filesystem cache is not being re-used by the database. Which of the following should be used to fix this problem?（）A、vmo to adjust the maxperm valueB、schedo to adjust the mempool sizeC、ioo to modify the maxpgahead valueD、bosboot to reassign the memory cache size

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

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

  • 第1题：

    You observe that 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 the 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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

    正确答案:B

  • 第5题：

    Which component of the SGA stores parsed SQL statements is used for process sharing?（）

    • A、Buffer cache 
    • B、Redo log buffer 
    • C、Private SQL area 
    • D、Library cache 
    • E、Row cache 

    正确答案:C

  • 第6题：

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


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

  • 第7题：

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

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

    单选题
    Which Coherence caching pattern matches the sequence of events ？（）  1. Data is requested from cache  2. The requested data does not exist in the cache （cache miss）  3. The Coherence cache store is used to red data from the back-end persistent data source， and placed in ther cache  4. Data requested from the cache is returned to the caller
    A

     read through

    B

     write through

    C

     refresh ahead

    D

     write behind


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

  • 第10题：

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

  • 第11题：

    单选题
    You observe that 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 the 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）


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

  • 第12题：

    单选题
    A database application is installed on a server. The AIX default filesystem cache is not being re-used by the database. Which of the following should be used to fix this problem?（）
    A

    vmo to adjust the maxperm value

    B

    schedo to adjust the mempool size

    C

    ioo to modify the maxpgahead value

    D

    bosboot to reassign the memory cache size


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

  • 第13题：

    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

    正确答案:A

  • 第14题：

    Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）

    • A、Data blocks have to be written more frequently by DBWR. 
    • B、Redo blocks have to be written more frequently by LGWR. 
    • C、You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. 
    • D、You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.

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

    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

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

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


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

  • 第19题：

    单选题
    You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL> SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）
    A

    Because 4194304 is the granule size

    B

    Because 4194304 is the standard block size

    C

    Because 4194304 is the largest nonstandard block size defined in the database

    D

    Because 4194304 is the total size of data already available in the database buffer cache


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

  • 第20题：

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

  • 第21题：

    单选题
    Which statement correctly describes the function of Oracle9i Cache Fusion feature？（）
    A

    It provides each session with its own view of the database at a different point in the past. 

    B

    It enables you to execute scalable applications on a clustered database without having to partition the users or the database tables. 

    C

    It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes. 

    D

    It allows you to add new sites to multimaster replication environment without quiescing the master definition site.


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

  • 第22题：

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


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

  • 第23题：

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

  • 第24题：

    单选题
    A consultant has been asked to do a performance analysis on a database server.  Which subsystem should the consultant first analyze and why？（）
    A

    CPU，because the database replication process requires a considerable amount of CPU time

    B

    Memory，because the buffer cache requires a large amount of memory to maintain the data in system memory

    C

    Disk，because it is important to configure a sufficient number of disks to match the CPU processing power

    D

    Network，because the data returned to the client from the server can be a large subset of the total database


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

相关内容