Home > Practice Exams > Oracle Corporation
Oracle 9i OCP Database Performance Tuning Practice Test
Covers objectives for Oracle Certified Professional (OCP) exam 1Z0-033. 150 questions.
Available Training Formats:
 Download |
 Online |
 (current price & free demo via our partner's website) |
Product Details:
Test Engine Features:- Questions are similar to exam questions so you test your knowledge of exam objectives
- Detailed answer explanations reinforce the material
- Study mode covers all objectives ensuring topics are covered
- Certification mode prepares students for exam taking conditions
This test contains 150 questions and covers the following objectives:
- Overview of Oracle 9i Performance Tuning - 14 questions
- Diagnostic and Tuning Tools - 14 questions
- Sizing the Shared Pool - 16 questions
- Sizing the Buffer Cache - 16 questions
- Sizing other SGA Structures - 8 questions
- Database Configuration and other I/O Issues - 12 questions
- Optimize Sort Operations - 8 questions
- Diagnosing Contention for Latches - 7 questions
- Tuning Rollback (or UNDO) Segments - 10 questions
- Monitoring and Detecting Lock Contention - 11 questions
- Tuning Oracle Shared Server - 6 questions
- Application Tuning - 8 questions
- Using Oracle Blocks Efficiently - 13 questions
- SQL Statement Tuning - 5 questions
- Tuning the Operating System and Using Resources - 2 questions
- Oracle9i: Database Performance Tuning
- OCP Oracle9i Database: Performance and Tuning Exam Guide
(current price & free demo via our partner's website)