11g-OCA(1Z0-047)-practice-test
Oracle Certified Associate OCA(1Z0-047) 11g practice exams
| Practice test vendor | Total number of questions | Number of questions in demo | Test Revision, file size | Price | Practice exam page |
|---|---|---|---|---|---|
| ucertify | 308 | 15 | NA | $74.98 | 1Z0-047 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-047 Oracle Database SQL Expert Exam Information
Duration: 120 minutes
Number of Questions: 70
Passing Score: 66%(subject to change)
Exam Topics(Brief) :
- Writing Basic SQL Select Statements
- 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
- Managing Objects with Data Dictionary Views
- Controlling User Access
- Managing Schema Objects
- Manipulating Large Data Sets
- Generating Reports by Grouping Related Data
- Retrieving Data Using Subqueries
References
1. http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=198&p_org_id=&lang=