Home >Oracle

 

 Oracle Certified Associate OCA(1Z0-051) 11g practice exams

vendor

Total number of questions

Number of 
questions
in demo

Test Revision Size

Price

Download

Transcender 212 NA NA $149 OCA 1Z0-051 Practice Test Page
ucertify 211 15 NA $74.98 OCA 1Z0-051 Practice Test Page

* Price, number of questions, and file size are as per the vendor's website, and likely to get modified from time to time. Please check with the vendor's website for current information. Any corrections or updates may please be sent to webmaster@practicetests.info


CONTENTS :

ORACLE 11g OCA (Oracle Certified Associate)

  1. Exam Details
  2. Exam Information


Additional Information :

References


ORACLE 11g OCA (Oracle Certified Associate) Exam Details :

Oracle Database 11g extends Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation.

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.

The exams to be taken for OCA certification are:

1Z0-001(Retired) Introduction to Oracle: SQLand PL/SQL

OR

1Z0-007 Introduction to Oracle9i SQL

OR

1Z0-047 Oracle Database SQL Expert

OR

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

AND

1Z0-052 Oracle Database 11g: Administration I



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

Duration                        : 120 minutes

Number of Questions    : 70

Passing Score                : 60 %(subject to change) 

Exam Topics(Brief)       :

  1. Retrieving Data Using the SQL SELECT Statement
  2. Restricting and Sorting Data
  3. Using Single-Row Functions to Customize Output
  4. Reporting Aggregated Data Using the Group Functions
  5. Displaying Data from Multiple Tables
  6. Using Subqueries to Solve Queries
  7. Using the Set Operators
  8. Manipulating Data
  9. Using DDL Statements to Create and Manage Tables
  10. Creating other Schema Objects
  11. Using Conversion Functions and Conditional Expressions


References:

1. http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=198&p_org_id=&lang=


Retired Exams

Disclaimer