单选题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?（）

Configure the KEEP buffer pool and alter the table with the corresponding storage clause.

Increase the database buffer cache size.

Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.

Configure Automata Shared Memory Management.

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 configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A、 streams poolB、 shared poolC、 log bufferD、 keep buffer cacheE、 recycle buffer cache

点击查看答案
第2题

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

点击查看答案
第3题

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

点击查看答案
第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 poolB、streams poolC、keep buffer cacheD、recycle buffer cache

点击查看答案
第5题

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 triggersB、by using Data PumpC、by using external tablesD、by using anonymous PL/SQL blocks

点击查看答案
第6题

单选题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 poolB streams poolC keep buffer cacheD recycle buffer cache

点击查看答案
第7题

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

点击查看答案

1Z0-060

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

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容