Get the latest IT certification news by email when you subscribe to GoCertify
Certification Update


GoCertify: The complete computer certification resource center.

GoExam: Certification practice tests with free demos to download.

CertificationBooks: Find the certification book you're looking for.




Home > Training > 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:

online subscription
     training demo link
(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
Core Test Information:

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
This test includes references to the following media:
  • Oracle9i: Database Performance Tuning
  • OCP Oracle9i Database: Performance and Tuning Exam Guide

training demo link
(current price & free demo via our partner's website)