Oracle Certified Associate (OCA)

Book this course Online now & get 10% Discount on Course Fee

Course contents:


Introduction :

Oracle certifications are industry-recognized credentials that signifies a proven level of knowledge and skills to succeed in IT career and to improve professional development and productivity.

Oracle Database 11g Administrator Certification

combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industry’s most advanced database management system. Oracle Database 11g extends Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation.

Objective of OCA 11g Certification Exam :

Oracle Certified Associate (OCA) 11g

is an entry-level certification designed to certify foundation skills required for database administration or application development.Its objectives are intended to test a candidate’s ability to work as a junior team member with database administrators or application developers. This certification can be considered as the first step towards the more advanced OCP 11g certification.

OCA 11g Certification Requirements :

1Z0-052 Oracle Database 11g: Administration I

  • Duration: 90 minutes
  • Number of Questions: 70
  • Passing Score: 66 %(subject to change)

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

    • Duration: 120 minutes
    • Number of Questions: 70
    • Passing Score: 60 %(subject to change)

    IZO-052 Oracle Database 11g: Administration

    • Exploring the Oracle Database Architecture
    • Preparing the Database Environment
    • Creating an Oracle Database
    • Managing the Oracle Instance
    • Configuring the Oracle Network Environment
    • Managing Database Storage Structures
    • Administering User Security
    • Managing Schema Objects,Data and Concurrency,Undo Data
    • Implementing Oracle Database Security
    • Database Maintenance
    • Performance Management
    • Backup and Recovery Concepts
    • Performing Database Backups and Database Recovery
    • Intelligent Infrastructure Enhancements

    1Z0-051 Oracle Database 11g : SQL Fundamentals

    • Retrieving Data Using the SQL SELECT Statement
    • Restricting and Sorting Data
    • Using Single-Row Functions to Customize Output
    • Reporting Aggregated Data Using the Group Functions
    • Displaying Data from Multiple Tables
    • Using Subqueries to Solve Queries
    • Using the Set Operators
    • Manipulating Data
    • Using DDL Statements to Create and Manage Tables
    • Creating other Schema Objects
    • Using Conversion Functions and Conditional Expressions