Oracle Certified Associate Certification

Oracle Certified Associate Certification

oca-logo

Oracle Certified Associate Certification Exam :

  • Step 1 – Pass One Exam
    Oracle Database 11g: SQL Fundamentals I Exam Number : (1Z0-051)
    OR
    Oracle Database SQL Expert Exam Number : 1Z0-047
  • Step 2 – Pass Exam
    Oracle Database 11g: Administration I Exam Number : (1Z0-052)Complete the above 2 exams to become “Oracle Database 11g Administrator Certified Associate Certification-OCA”

Syllabus for Oracle Certified Associate Certification Exam

Oracle Database 11g: SQL Fundamentals I Exam Number : (1Z0-051)
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Sub queries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
Oracle Database 11g: Administration I Exam Number : (1Z0-052)
  • 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 Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Intelligent Infrastructure Enhancements
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data

Drop us a query

Testimonials

user
user
user
user
user
user