Oracle's 1Z0-051

Oracle Database 11g: SQL Fundamentals I - OCA

The Oracle Database 11g: SQL Fundamentals I is an industry recognized credential. The certification is proof of a person's competence across a spectrum of skills including understanding SQL programming language. uCertify’s guaranteed certification course for 1Z0-051 exam is comprehensive and helps you earn your certification and gain knowledge. Here’s what to expect from your uCertify course:

• 100% Exam Coverage • Interactive E-Book • Pre-Assessment • 554 Practice Questions with Full Explanations • 377 Interactive Quizzes • Test History and Performance Review and Powerful Analytics • Study Planner • Continuously Updated



The 1Z0-051 exam is a part of Oracle's Database 11g SQL Fundamental certification which comprises of two exams. It is required part to the certification.

The certification is targeted at developers and database administrators who want to design, develop and manage SQL based applications with the Oracle database.

This exam provides credit towards the following certifications:

  • Oracle Database 11g Administrator Certified Associate
  • Oracle Database 10g Administrator Certified Associate

Skills Measured

  • Retrieval of Data using SQL Select Statement
  • Restricting, Manipulating and Sorting Data
  • Use of Single-Row Functions to Customize Output
  • Conversion functions and Conditional Expressions
  • DDL Statements to create and manage tables
  • Creation of Schema Objects
  • Aggregated Data using Group Functions
  • Multiple Tables

Related Certifications

1Z0-051 Course Duration

This is a self-paced, independent study program, so there are no minimum or maximum restrictions placed by uCertify. The amount of time you will take depends on your existing knowledge of the area and related experience, as well as your availability. We recommend at least 2 weeks if you have a fundamental knowledge of SQL and a good understanding of relational databases.

Related Exams

Authored by Industry Experts

uCertify uses content from the finest publishers and only the IT industry's finest instructors. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can study at your own pace. This creates a personal learning experience and gives you all the benefits of hands-on training with the flexibility of doing it around your schedule 24/7.

Exercises, Quizzes & Flashcards

uCertify's exercises, quizzes and flashcards prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes, flashcards and exercises after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course.

Practice Test Sets

uCertify courses also include full length practice test sets designed to test your knowledge under real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure you are 100% prepared before taking your certification exam.

Exam Simulators

Online labs to supplement your training. uCertify labs are an inexpensive & safe way to explore and learn. uCertify labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

State of the Art Educator Tools

uCertify knows the importance of instructors and provide tools to help them do their job effectively. Instructors are able to clone and customize course, do ability grouping, create sections, design grade scale and grade formula, create and schedule assignments. Educators can also move a student from self-paced to mentor-guided to instructor-led mode in three clicks.

Award Winning Learning Platform (LMS)

uCertify has developed an award winning, highly interactive yet simple to use platform. uCertify understands that it is critical to help student focus on learning the subject and not learning the LMS. uCertify helps student retain and recall the knowledge by teaching students using interactive exercises. Features such as actionable analytics and study planner help in keeping students focused.


1Z0-051 Course/Exam Objectives

  • Lesson 1: Introducing SQL
    • Overview
    • SQL Fundamentals
    • Writing Simple Queries
    • Accepting Values at Runtime
    • Summary
    • Exam Essentials
    • Review Questions
  • Lesson 2: Using Single-Row Functions
    • Overview
    • Single-Row Function Fundamentals
    • Using Single-Row Character Functions
    • Using Single-Row Numeric Functions
    • Using Single-Row Date Functions
    • Using Single-Row Conversion Functions
    • Using Other Single-Row Functions
    • Summary
    • Exam Essentials
    • Review Questions
  • Lesson 3: Using Group Functions
    • Overview
    • Group-Function Fundamentals
    • Utilizing Aggregate Functions
    • Summary
    • Exam Essentials
    • Review Questions
  • Lesson 4: Using Joins and Subqueries
    • Overview
    • Writing Multiple-Table Queries
    • Using Set Operators
    • Subqueries
    • Summary
    • Exam Essentials
    • Review Questions
  • Lesson 5: Manipulating Data
    • Overview
    • Using DML Statements
    • Understanding Transaction Control
    • Summary
    • Exam Essentials
    • Review Questions
  • Lesson 6: Creating Tables and Constraints
    • Overview
    • Database Objects Overview
    • Built-in Datatypes
    • Creating Tables
    • Modifying Tables
    • Managing Constraints
    • Summary
    • Exam Essentials
    • Review Questions
  • Lesson 7: Creating Schema Objects
    • Overview
    • Creating and Modifying Views
    • Creating and Managing Sequences
    • Creating and Managing Synonyms
    • Creating and Managing Indexes
    • Summary
    • Exam Essentials
    • Review Questions

Career Prospects

An Oracle's 11g DBA OCA Certified Professional has several career opportunities open up to them, including:

  • Application Developer
  • PL/SQL Developer
  • Forms Developer
  • Database Administrator
  • System Analyst
  • Business Analyst
  • Data Warehouse Administrator


1Z0-051 Exam FAQs

What certificate do I earn on passing the 1Z0-051 exams?
What is the exam registration fee?
USD 125

Pricing and taxes may vary from country to country.

Where do I take the exam?
The 1Z0-051 exam is administered by Pearson VUE at testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam?
The exam consists of multiple choice questions.
What is the Pre-requisites of the exam?
While there are no official prerequisites to take the OCA DBA 11g certification, both Oracle and uCertify strongly recommend that the candidates should have a good understanding of relational database concepts.
How many questions are asked on the exam?
The exam contains 66 questions.
What is the duration of the exam?
120 minutes
What is the passing score?

(on a scale of 0-1000)

What is the exam's retake policy?

In the event that you fail your first attempt at passing the 1Z0-051 exam, Oracle's retake policy is:

  • You must wait 14 days before retaking a failed exam.
  • Passed exams and Beta exams cannot be re-taken.
  • Candidates may retake an online non-proctored exam at any time
What is the validity of the certification?
An Oracle's OCA DBA 11g certification has no expiration. The certification holder is certified for life unless Oracle changes their policy. Click here for more information.
Where can I find more information about this exam?
To know more about the 1Z0-051 exam, click here.

At a Glance

1Z0-051 Course Includes Free Buy
Lessons 1 7
Pre-Assessment Yes Yes
Practice Tests 0 10
Total Questions 15 554
Interactive Quizzes 0 377
Final Test No Yes

Copyright © 2014 uCertify / All rights reserved.