Performance Tuning   «Prev  Next»
 

Oracle Performance Tuning Overview - Quiz



1. What area of Oracle tuning has the most impact on system performance?
Please select the best answer.
  A. Logical design tuning
  B. Physical design tuning
  C. SGA tuning
  D. SQL tuning

2. Which of the following tuning techniques will NOT reduce the disk I/O for an Oracle query?
Please select the best answer.
  A. Add blocks to the SGA buffer pool
  B. Create a clustered table
  C. Create tables with redundant columns from other tables
  D. Run parallel query against the table

3. Which of the following are important Oracle tuning metrics?
Please select all the correct answers.
  A. Buffer hit ratio
  B. Library cache hit ratio
  C. Buffer busy waits
  D. Full-table scans

4. Which statement best describes the purpose of de-normalization?
Please select all the correct answers.
  A. To eliminate data redundancy in the data model
  B. To make SQL updates run faster
  C. To make SQL queries run faster
  D. To save disk storage space

5. Which of the following columns is the best candidate for redundant duplication in another Oracle table?
Please select the best answer.
  A. Gender
  B. Home_address
  C. Current_employer
  D. Service_history