Anandsoft at 09:51, 31 March 2022

2022-03-31T09:51:22Z

← Older revision		Revision as of 05:51, 31 March 2022
Line 47:		Line 47:

	==== ORACLE 11g OCA (Oracle Certified Associate) Exam Details ====		==== ORACLE 11g OCA (Oracle Certified Associate) Exam Details ====
			<span id="details"></span>
	Oracle Database 11g extends Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation.		Oracle Database 11g extends Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation.

Line 72:		Line 73:

	==== 1Z0-001 Introduction to Oracle: SQL and PL/SQL Exam Information ====		==== 1Z0-001 Introduction to Oracle: SQL and PL/SQL Exam Information ====
			<span id="info"></span>
	Duration: 120 minutes		Duration: 120 minutes

Line 92:		Line 94:
	* Restricting and Sorting Data		* Restricting and Sorting Data
	* Handing Exceptions		* Handing Exceptions
	* Subqueries,Multiple-Column Subqueries		* Subqueries, Multiple-Column Subqueries
	* Displaying Data from Multiple Tables		* Displaying Data from Multiple Tables

	==== References ====		==== References ====
			<span id="references"></span>
	1. <nowiki>http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=198&p_org_id=&lang=</nowiki>		1. <nowiki>http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=198&p_org_id=&lang=</nowiki>

Anandsoft: Created page with "== Oracle Certified Associate OCA(1Z0-001) 11g practice exams == {| class="wikitable" !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-001 Practice Test Page |- |Transcender |307 |NA |NA |$119 |OCA 1Z0-001 Practice Test page |- |ucertify |301 |15 |NA |$39.99 |1Z0-001 Practice Test Page |- |Boson |204 |NA |NA |$39.95 |OCA 1Z0-001 Practice Test Page..."

2022-03-31T09:50:53Z

Created page with "== Oracle Certified Associate OCA(1Z0-001) 11g practice exams == {| class="wikitable" !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-001 Practice Test Page |- |Transcender |307 |NA |NA |$119 |OCA 1Z0-001 Practice Test page |- |ucertify |301 |15 |NA |$39.99 |1Z0-001 Practice Test Page |- |Boson |204 |NA |NA |$39.95 |OCA 1Z0-001 Practice Test Page..."

New page

== Oracle Certified Associate OCA(1Z0-001) 11g practice exams ==
{| class="wikitable"
!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-001 Practice Test Page
|-
|Transcender
|307
|NA
|NA
|$119
|OCA 1Z0-001 Practice Test page
|-
|ucertify
|301
|15
|NA
|$39.99
|1Z0-001 Practice Test Page
|-
|Boson
|204
|NA
|NA
|$39.95
|OCA 1Z0-001 Practice Test Page
|}
<nowiki>*</nowiki>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) ===

* [[11g-OCA(1Z0-001)-practice-test#details|Exam Details]]
* [[11g-OCA(1Z0-001)-practice-test#info|Exam Information]]
* [[11g-OCA(1Z0-001)-practice-test#references|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 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-001 Introduction to Oracle: SQL and PL/SQL Exam Information ====
Duration: 120 minutes

Number of Questions: 57

Passing Score: 68%(subject to change)

'''Exam Topics(Brief) :'''

* Creating and Managing Tables
* Including Constraints
* Create and maintain constraints
* Oracle Data Dictionary
* Writing Control Structures
* Working with Composite Datatypes
* Overview of Relational Databases, SQL, and PL/SQL
* Aggregating Data using Group Functions
* Controlling User Access
* Writing Basic SQL Statements
* Restricting and Sorting Data
* Handing Exceptions
* Subqueries,Multiple-Column Subqueries
* Displaying Data from Multiple Tables

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

11g-OCA(1Z0-001)-practice-test - Revision history

Anandsoft at 09:51, 31 March 2022