RelationalDBDesign RelationalDBDesign 

Business Requirements   «Prev  Next»

Overall Tuning Strategies - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following tuning measures is independent of hardware resources? Please select the best answer.
  A. Data buffer hit ratio
  B. Disk sorts
  C. Redo log space requests
  D. Full-table scans

2. Disk related slowdowns are most likely the result of what condition? Please select the best answer.
  A. Contention within the Oracle data buffer (buffer busy waits)
  B. Disk I/O bottlenecks
  C. High disk sorts
  D. High buffer hit ratio

3. Which of the following changes require bouncing your Oracle database? (Check all that apply) Please select all the correct answers.
  A. Add blocks to db_block_buffer
  B. Add blocks to shared_pool_size
  C. Add a data file to a tablespace
  D. Increase the process parameter

4. Which is not an option when capturing long-term Oracle performance data? Please select the best answer.
  A. Use a third-party product to capture and display Oracle data
  B. Write a custom Oracle database to store long-term Oracle data
  C. Use the standard Oracle utilities to store long-term data