单选题Which is the correct description of a pinned buffer in the database buffer cache（）A The buffer is currently being accessed.B The buffer is empty and has not been used.C The contents of the buffer have changed and must be flushed to the disk by the DBWn

题目
单选题
Which is the correct description of a pinned buffer in the database buffer cache（）
A

The buffer is currently being accessed.

B

The buffer is empty and has not been used.

C

The contents of the buffer have changed and must be flushed to the disk by the DBWn process. 

D

The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.

相似考题

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 statement describes queue and buffer managment in the E－series router?()A. Buffer memory is managed dynamically in the I/O module.B. Buffer memory is managed dynamically in the switch fabric.C. Buffer memory is managed dynamically on egress line modules.D. Buffer memory is managed dynamically on ingress line modules

3.在执行“LEA BX，BUFFER”指令时，是把（）。A、BUFFER的内容→BXB、BUFFER的偏移量→BXC、BUFFER的段基值→BXD、BUFFER的内容→EA

4.In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.On further investigation, you find that buffer busy waits is caused by contention on data blocks.Which option would you consider first to decrease the wait event immediately?（）A. Decreasing PCTUSEDB. Decreasing PCTFREEC. Increasing the number of DBWN processD. Using Automatic Segment Space Management (ASSM)E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

更多“单选题Which is the correct description of a pinned buffer in the database buffer cache（）A The buffer is currently being accessed.B The buffer is empty and has not been used.C The contents of the buffer have changed and must be flushed to the disk by the DBWn”相关问题

  • 第1题：

    Which item is the great majority of software vulnerabilities that have been discovered？（）

    • A、Stack vulnerabilities
    • B、Heap overflows
    • C、Software overflows
    • D、Buffer overflows

    正确答案:D

  • 第2题：

    Which statement describes queue and buffer managment in the E-series router?（）

    • A、Buffer memory is managed dynamically in the I/O module.
    • B、Buffer memory is managed dynamically in the switch fabric.
    • C、Buffer memory is managed dynamically on egress line modules.
    • D、Buffer memory is managed dynamically on ingress line modules

    正确答案:C

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）

    • A、Decreasing PCTUSED
    • B、Decreasing PCTFREE
    • C、Increasing the number of DBWN process
    • D、Using Automatic Segment Space Management (ASSM)
    • E、Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

    正确答案:D

  • 第7题：

    Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users？（）

    • A、IGNORE=Y
    • B、DIRECT=Y
    • C、CONSISTENT=Y
    • D、BUFFER=Y

    正确答案:C

  • 第8题：

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

  • 第9题：

    单选题
    You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）
    A

    The advisory memory has been turned off.

    B

    The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.

    C

    The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.

    D

    The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.

    E

    The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.


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

  • 第10题：

    单选题
    In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）
    A

    Decreasing PCTUSED

    B

    Decreasing PCTFREE

    C

    Increasing the number of DBWN process

    D

    Using Automatic Segment Space Management (ASSM)

    E

    Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation


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

  • 第11题：

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

  • 第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 of the following provides a logical grouping of database objects?（）

    • A、View
    • B、Table
    • C、Schema
    • D、Buffer pool

    正确答案:C

  • 第14题：

    Which is the correct description of a pinned buffer in the database buffer cache（）

    • A、The buffer is currently being accessed.
    • B、The buffer is empty and has not been used.
    • C、The contents of the buffer have changed and must be flushed to the disk by the DBWn process. 
    • D、The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.

    正确答案:A

  • 第15题：

    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

  • 第16题：

    You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）

    • A、The advisory memory has been turned off.
    • B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
    • C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
    • D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
    • E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

    正确答案:C

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    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

  • 第20题：

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

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

    单选题
    Which is the correct description of a pinned buffer in the database buffer cache（）
    A

    The buffer is currently being accessed.

    B

    The buffer is empty and has not been used.

    C

    The contents of the buffer have changed and must be flushed to the disk by the DBWn process. 

    D

    The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.


    正确答案： C
    解析： Every buffer has an access mode:pinnedorfree(unpinned). A buffer is "pinned" in the cache so that it does not age out of memory while a user session accesses it. Multiple sessions cannot modify a pinned buffer at the same time.

  • 第23题：

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

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

相关内容