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

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

相似考题

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

3.You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）A、 recycle buffer cacheB、 large poolC、 streams poolD、 keep buffer cacheE、 redo log buffer

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

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

  • 第1题：

    You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）

    • A、by using the ANALYZE utility
    • B、by using the DBVERIFY utility
    • C、by using the DB_BLOCK_CHECKING parameter
    • D、by using the DBMS_REPAIR package

    正确答案:D

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

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

  • 第6题：

    单选题
    You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）
    A

    by using the ANALYZE utility

    B

    by using the DBVERIFY utility

    C

    by using the DB_BLOCK_CHECKING parameter

    D

    by using the DBMS_REPAIR package


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

  • 第7题：

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

  • 第8题：

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

  • 第9题：

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

  • 第10题：

    单选题
    You suspect unauthorized data manipulation language （DML） operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis.  How would you achieve this（）
    A

    by using triggers

    B

    by using Data Pump

    C

    by using external tables

    D

    by using anonymous PL/SQL blocks


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

    单选题
    You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）
    A

     recycle buffer cache

    B

     large pool

    C

     streams pool

    D

     keep buffer cache

    E

     redo log buffer


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

  • 第13题：

    In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）

    • A、The modified blocks would be written to the data files.
    • B、The modified blocks would be written to the temp files.
    • C、The modified blocks would be written to the control file.
    • D、The modified blocks would be written to the redo log files.
    • E、The modified blocks would be written to the archived redo log files.
    • F、The modified blocks would be retained in the database buffer cache.

    正确答案:A

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You suspect unauthorized data manipulation language （DML） operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis.  How would you achieve this（）

    • A、by using triggers
    • B、by using Data Pump
    • C、by using external tables
    • D、by using anonymous PL/SQL blocks

    正确答案:A

  • 第17题：

    单选题
    In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）
    A

    The modified blocks would be written to the data files.

    B

    The modified blocks would be written to the temp files.

    C

    The modified blocks would be written to the control file.

    D

    The modified blocks would be written to the redo log files.

    E

    The modified blocks would be written to the archived redo log files.

    F

    The modified blocks would be retained in the database buffer cache.


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

  • 第18题：

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


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

  • 第19题：

    单选题
    You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
    A

    table 

    B

    transactional trigger 

    C

    stored procedure 

    D

    FROM clause query


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

  • 第20题：

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

  • 第21题：

    多选题
    You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
    A

    Average row size

    B

    Last analyzed date

    C

    Size of table in bytes

    D

    Size of table in database blocks

    E

    Number of free blocks in the free list

    F

    Number of extents present in the table.


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

  • 第22题：

    多选题
    You work as a database administrator for Certkiller .com. In your development environmentenvironment， the developers are responsible for modifying the table structure according to the application requirements. However， you want to keep track of the ALTER TABLE commands being executed by developers， so you enable auditing to achieve this objective.  Which two views would you refer to find out the audit information？（）
    A

    DBA_AUDIT_TRAIL

    B

    DBA_AUDIT_SESSION

    C

    DBA_FGA_AUDIT_TRAIL

    D

    DBA_COMMON_AUDIT_TRAIL


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

  • 第23题：

    单选题
    Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）
    A

    Java pool

    B

    Large pool

    C

    Shared pool

    D

    Streams pool

    E

    Library cache

    F

    Redo log buffer

    G

    Data dictionary cache

    H

    Database buffer cache


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

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

相关内容