1Z0-051 - Oracle Database 11g: SQL Fundamentals I - OCA

The Oracle 11g Administrator Certified Associate (OCA) certification is a streamlined, entry-level certification for the database-administration track and is required to advance toward the more senior certification tiers.
1Z0-051 - Oracle Database 11g: SQL Fundamentals I  - OCA


uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keeps the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. Learners can do Flashcards, Exercises, Quizzes and Labs related to each chapter. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keeps learners engaged and makes learning fun.

Here's What You Get

Exercises, Flashcards, Quizzes & Glossary

Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts while Glossary defines the key terms.

Exercise Questions
Glossary of terms

Here's What you will Learn

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

Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
Full Length Tests
Post-Assessments Questions


Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Exam Information

Certification is proof of your knowledge and shows that you have the skills required to support Oracle core products. The Oracle certification program can help a company identify proven performers who have demonstrated their skills and who can support the company's investment in Oracle technology. It demonstrates that you have a solid understanding of your job role and the Oracle products used in that role.

Career Prospects
  • Application Developer
  • PL/SQL Developer
  • Database Administrator
  • Data Warehouse Administrator
Exam FAQs
What is the exam registration fee?
USD 125

Pricing and taxes may vary from country to country. Click here for more information on exam pricing.

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 scenario-based multiple choice questions.
What are 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 SQL.
How many questions are asked in the exam?
The exam contains 64 questions.
What is the duration of the exam?
120 minutes
What is the passing score?


Click here for more information.

What is the exam's retake policy?

Retake Policy for Oracle 1Z0-051 exam is:

  • Candidates must wait 14 days before retaking a failed proctored exam. (Registration will be allowed on the 14th day)
  • Candidates may retake an online non-proctored exam at any time.
  • Candidates may not retake a passed exam at any time.
  • Candidates may not retake a beta 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, click here.

Copyright © 2014 uCertify / All rights reserved.