Scroll to top button

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.

Here's what you will get

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.

Lessons
Lessons
7+
Exercises
554+
Quizzes
377+
Flashcards
115+
Glossary of terms
115+
Test prep
Pre-assessment Questions
15+
Full Length Tests
10+
Post-Assessment Questions
51+
Exam FAQs
What is the exam registration fee? USD 125
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?

60%

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. Clickhere for more information.
Where can I find more information about this exam? To know more about the 1Z0-051, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Application Developer
  • PL/SQL Developer
  • Database Administrator
  • Data Warehouse Administrator

Here's what you will learn

  • Overview
  • SQL Fundamentals
  • Writing Simple Queries
  • Accepting Values at Runtime
  • Summary
  • Exam Essentials
  • Review Questions
  • 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
  • Overview
  • Group-Function Fundamentals
  • Utilizing Aggregate Functions
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Writing Multiple-Table Queries
  • Using Set Operators
  • Subqueries
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Using DML Statements
  • Understanding Transaction Control
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Database Objects Overview
  • Built-in Datatypes
  • Creating Tables
  • Modifying Tables
  • Managing Constraints
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Creating and Modifying Views
  • Creating and Managing Sequences
  • Creating and Managing Synonyms
  • Creating and Managing Indexes
  • Summary
  • Exam Essentials
  • Review Questions
1Z0-051 1Z0-051
1Z0-051
Oracle Database 11g: SQL Fundamentals I - OCA
ISBN : 9781616911881

Copyright © 2002-2019 uCertify / All Rights Reserved.