Oracle Database 11g Data Warehousing Essentials

Oracle Database 11g Data Warehousing Essentials

The Oracle Database 11g Data Warehousing Essentials (1Z0-515) exam is primarily intended for professionals that are skilled in implementing solutions based using the Oracle Database as a data warehouse. The certification covers skills such as: data warehouse fundamentals, parallelism, partitioning, the Result Set Cache, Advanced Compression, using Oracle Data Mining, data integration with ODI and OWB, the Exadata Storage Server and the Sun Oracle Database Machine and best practices for implementing data warehouses. The exam targets the intermediate-level implementation team member. Up-to-date training and field experience are recommended.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. This certification helps their companies qualify for the Oracle Database 11g Data Warehousing Specialization.

This OPN Certified Implementation Specialist exam is now available in English, Simplified Chinese and Korean!

Exam Number:
120 minutes
Associated Certifications:
Oracle Database 11g Data Warehousing Certified Implementation Specialist

OPN Certified Specialist
Number of
Exam Price:
US $245

More on exam pricing

Passing score subject to change.
View Details
Exam Validation:
Exam validated against release 11g
Exam Format:
Multiple Choice


Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy

Recommended Training
Oracle Database 11g Data Warehousing Essentials - Exam Study Guide
OPN Guided Learning Path
Oracle Database 11g Data Warehousing Implementation Specialist
OPN Guided Learning Path
Oracle University Training
Oracle Database 11g: Data Warehousing Fundamentals


Additional Information & Resources
Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)


Exam Topics

Overview of Data Warehousing

  • Describe the benefits of a data warehouse
  • Describe the technical characteristics of a data warehouse
  • Describe the Oracle Database structures used primarily by a data warehouse
  • Explain the use of materialized views
  • Implement Database Resource Manager to control resource usage
  • Identify and explain the benefits provided by standard Oracle Database 11g enhancements for a data warehouse


  • Explain how the Oracle optimizer determines the degree of parallelism
  • Configure parallelism
  • Explain how parallelism and partitioning work together


  • Describe types of partitioning
  • Describe the benefits of partitioning
  • Implement partition-wise joins

Result Cache

  • Describe how the SQL Result Cache operates
  • Identify the scenarios which benefit the most from Result Set Caching


  • Explain how Oracle OLAP delivers high performance
  • Describe how applications can access data stored in Oracle OLAP cubes.

Advanced Compression

  • Explain the benefits provided by Advanced Compression
  • Explain how Advanced Compression operates
  • Describe how Advanced Compression interacts with other Oracle options and utilities

Data integration

  • Explain Oracle's overall approach to data integration
  • Describe the benefits provided by ODI
  • Differentiate the components of ODI
  • Create integration data flows with ODI
  • Ensure data quality with OWB
  • Explain the concept and use of real-time data integration
  • Describe the architecture of Oracle's data integration solutions

Data mining and analysis

  • Describe the components of Oracle's Data Mining option
  • Describe the analytical functions provided by Oracle Data Mining
  • Identify use cases that can benefit from Oracle Data Mining
  • Identify which Oracle products use Oracle Data Mining


  • Properly size all resources to be used in a data warehouse configuration


  • Describe the architecture of the Sun Oracle Database Machine
  • Describe configuration options for an Exadata Storage Server
  • Explain the advantages provided by the Exadata Storage Server

Best practices for performance

  • Employ best practices to load incremental data into a data warehouse
  • Employ best practices for using Oracle features to implement high performance data warehouses


Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.

 E-mail this page  Printer View