Oracle Database 11g Essentials

Oracle Database 11g Essentials

The Oracle Database 11g Essentials (1Z0-514) exam is primarily intended for implementation consultants that know how to install the Oracle Database 11g software and how to perform the tasks required to manage an Oracle database. 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 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 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 Essentials - Exam Study Guide (PDF)
OPN Guided Learning Path
Oracle Database 11g Implementation Specialist
Oracle University Training
Oracle Database 11g: 2 Day DBA Release 2  


Additional Information & Resources

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

This exam is valid for Oracle Database 11gR1 and 11gR2.


Exam Topics

Oracle Database Implementation

  • Explain the features of security options in Oracle Database 11g
  • Implement edition-based redefinition
  • Explain the grid-enabling features in Oracle Database 11g
  • Explain the enhanced manageability features in Oracle Database 11g

Overview of Oracle Database Administration

  • Describe the structure of a relational database and use of SQL
  • Identify the components of an Oracle instance and database
  • Describe the basic tasks that an Oracle DBA performs
  • Define the tools that are used to administer an Oracle database

Installing and Creating Oracle Database

  • Install the Oracle Database software
  • Create an Oracle database

Using Enterprise Manager Database Control & SQL*Plus

  • Start the Enterprise Manager dbconsole process
  • Access Enterprise Manager Database Control
  • Navigate in Enterprise Manager Database Control
  • Grant Enterprise Manager administrative privileges
  • Use SQL*Plus to access your database

Configuring the Oracle Network Environment

  • Describe the Oracle Network configuration
  • Use the Enterprise Manager Net Services Administration page for Oracle Network configuration
  • Use the Listener Control utility
  • Configure a client to access an Oracle database

Managing the Oracle Instance

  • Start up and shut down the Oracle instance
  • View the parameters that are used to configure the Oracle instance
  • Manage Oracle instance memory components

Managing Database Storage Structures

  • Use Oracle Enterprise Manager to view database storage structures
  • Create and manage storage structures in your database
  • Reclaim unused space in your database
  • Manage structures used to undo the changes that are made to the database and maintain consistency

Administering Users and Security

  • Create and administer users
  • Grant privileges to users to perform database operations
  • Create and manage roles

Managing Schema Objects

  • Create and modify database tables
  • View data in the database
  • Create additional database objects
  • Load data into tables

Performing Backup and Recovery

  • Configure the database for backup and recovery operations
  • Create and manage database backups
  • Restore and recover the database
  • Use flashback features
  • Describe the Oracle Self-Monitoring Architecture
  • Use the performance advisors to optimize database performance

Investigating, Reporting, and Resolving Problems

  • Use the Support Workbench to view critical error alerts
  • Package diagnostic data for uploading to Oracle Support

Managing Oracle Database Software

  • Keep your Oracle Database software up-to-date with patch and software releases
  • Upgrade a database


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