1. What is perhaps the greatest performance tuning technique that a DBA can perform?
2. When is it acceptable to create an index to support a single query?
3. Why is log file placement so important?
4. What is the primary benefit of database reorganization?
5. What is the cluster ratio of a database?
6. What is raw partitioning and why is it used?
7. How can partitioning be used to help accomplish parallelism?
8. What is the difference between a clustered and unclustered index?
9. What is the first consideration for file placement strategy?
10.  What is the purpose of dynamic performance tables in Oracle?

Use Assignment Uploader to submit