Data Buffer Cache   «Prev  Next»

Oracle Buffer Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. What is the best way to improve the buffer hit ratio for a small, frequently read table? (Choose all that apply)
Please select all the correct answers.
  A. Use the ALTER TABLE table1 CACHE; command.
  B. Use the RECYCLE pool for the table.
  C. Use the KEEP pool for the table.
  D. Use the DEFAULT pool for the table.

2. Which data buffer pool would be most appropriate for a table that is always accessed with a full-table scan?
Please select the best answer.
  A. KEEP pool
  B. RECYCLE pool
  C. DEFAULT pool

3. What is a possible remedy for a poor data buffer hit ratio? (Choose all that apply)
Please select the best answer.
  A. Increase db_block_buffer
  B. Tune queries to remove full-table scans
  C. Move large tables into the KEEP pool
  D. Increase db_file_multiblock_read_count

4. Which tuning technique would be the most beneficial for tuning a full-table scan against a very large Oracle table?
Please select the best answer.
  A. Re-setting db_file_multiblock_read_count to a higher value
  B. Segregating the table into the RECYCLE pool
  C. Segregating the table into the KEEP pool
  D. Increasing the value of db_block_buffer