11g-OCA(1Z0-007)-practice-test

From Practice Tests Info
Jump to navigation Jump to search

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

Practice test vendor Total number of questions Number of questions in demo Test Revision, file size Price Practice exam page
MeasureUp 151 NA NA Rs.684 OCA 1Z0-007 Practice Test Page
Transcender 245 NA NA $119 OCA 1Z0-007 Practice Test page
ucertify 280 15 NA $39.99 1Z0-007 Practice Test Page
Boson 187 NA NA $39.95 OCA 1Z0-007 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[at]practicetests.info

CONTENTS

ORACLE 11g OCA (Oracle Certified Associate)

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 Introduction to Oracle: SQL and 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-007 Introduction to Oracle: SQL and PL/SQL Exam Information

Duration: 120 minutes

Number of Questions: 52

Passing Score: 71%(subject to change)

Exam Topics(Brief) :

  • Writing Basic SQL Select Statements
  • Restricting and Sorting Data
  • Single-Row Functions
  • Displaying Data from Multiple Tables
  • Aggregating Data using Group Functions
  • Subqueries
  • Producing Readable Output with iSQL Plus
  • Manipulating Data
  • Creating and Managing Tables
  • Including Constraints
  • Creating Views
  • Creating Other Database Objects

References

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