Certification: Oracle PL/SQL Developer Certified Associate
Certification Full Name: Oracle PL/SQL Developer Certified Associate
Certification Provider: Oracle

Pass Your Oracle PL/SQL Developer Certified Associate Exams - 100% Money Back Guarantee!

Get Certified Fast With Latest & Updated Oracle PL/SQL Developer Certified Associate Preparation Materials

Oracle 1z0-071 Bundle

Questions & Answers

1z0-071 Questions & Answers

334 Questions & Answers

Includes questions types found on actual exam such as drag and drop, simulation, type in, and fill in the blank.

Training Course

1z0-071 Training Course

168 Video Lectures

Based on Real Life Scenarios which you will encounter in exam and learn by working with real equipment.

Study Guide

1z0-071 Study Guide

208 PDF Pages

Study Guide developed by industry experts who have written exams in the past. They are technology-specific IT certification researchers with at least a decade of experience at Fortune 500 companies.

Individual Product

1z0-144 Bundle

Oracle 1z0-144 Exam

Oracle Database 11g: Program with PL/SQL

2 Products

Includes 110 Questions & Answers, 202 Training Course.

Learn More About 1z0-144 Exam

Certification Prerequisites

No prerequisites.

Certification Notation

To get this certification you need to pass the following exams:

  1. 1z0-071 or 1z0-144

Certification Overview

This certification aims at building database centric internet applications for both oracle9i and Oracle Database 10g.

Who can do this certification?

Those who want to gain credibility, high level of efficiency and improved job performance in developing applications can take this certification.


Those holding this certificate can get employment as software engineers, senior software engineers, and senior technical consultants with salary hourly rate between INR 224,429k and 1,456968k

Associated Exams

In order for one to be conferred this certificate, one is required to pass two exams. The first exam is either of 1Z0-047 Oracle Database SQL Expert or 1Z0-051 Oracle Database 11g SQL Fundamentals I or 1Z0-061 Oracle Database 12c SQL Fundamentals. The second exam required is either 1Z0-147 Program with PL/SQL or 1Z0-144 Oracle Database 11g: Program with PL/SQL. For those who want to advance in this certification they are required to pass Oracle 11g Advanced PL/SQL 1Z0-146 exam, but this is after being certified as Oracle PL/SQL Developer Associate.


Skills in Oracle 9i and Oracle Database 10g

Oracle Database 11g: SQL Fundamentals I

Major topics

  1. Use the SQL SELECT Statement to Retrieve Data
  2. Customize Output Using Single-Row Functions
  3. Sorting Data and restricting it
  4. Use of Conditional Expressionsand Conversion Functions
  5. Use the Group Functions to report aggregated data
  6. Solve Queries by using sub-queries
  7. Data Display from Multiple Tables
  8. Use of the Set Operators
  9. Tables by use of DDL Statements and manage
  10. Creation Other Schema Objects
  11. Data Manipulation

Topics Covered

This exam is for a duration of 120 minutes and consist of 66 multiple choice questions. This exam is validated against Oracle Database 10g and Release 2 version

Oracle Database 12c: SQL Fundamentals

The exam understanding in 9 topics

  • Use the SQL SELECT Statement
  • Single-Row Functions
  • Restrict and Sort Data
  • Using Conversion Functions and Conditional Expressions
  • Multiple data display- Tables Using Joins
  • Solving queries
  • Group Functions- data reporting
  • Introduction to Data Definition Language
  • Managing Tables using DML statements

This exam consists of 75 multiple choice questions which take a duration of 120 minutes. The exam is validated against Oracle Database

1Z0-147 Program with PL/SQL Exam

Main topics

  • PL/SQL ProgramsOverview
  • Manipulating Large Objects
  • Creation of Procedures and Functions
  • Management of Subprograms
  • Package creation
  • More Package Concepts
  • Trigger Concepts
  • Creating Database Triggers
  • Dependencies Management
  • Oracle Supplied Packages

The exam consists of 66 multiple choice questions that cover a duration of 90 minutes. The exam is validated against 9i and 10g.

1Z0-144 Oracle Database 11g: Program with PL/SQL

This exam covers Oracle Database 11g: PL/SQL Fundamentals units and Oracle Database 11g; Develop PL/SQL Program Units. A full list of the units can be had from the provider's website. The exam consists of 63 multiple choice questions for a duration of 90 minutes. It is validated against Oracle Database 11g, Oracle Database 11g Release2 and Oracle Database 12c.

1Z0-146 Oracle Advanced PL/SQL Developer Certificate

Main topics

  • Review of the PL/SQL Programming Concepts
  • PL/SQL Code designing
  • Using Collections
  • Use of Advanced Interface Methods
  • VPD's Fine-Grained Access Control Implementation for Manipulating Large Objects
  • Tuning and Performance
  • Analyze of PL/SQL Code
  • Administration ofSecure File LOBs
  • Use Caching to Improve Performance
  • Code safeguard Against SQL Injection Attacks
  • Profiling PL/SQL Code and Tracing it

The exam covers 68 multiple choice questions for a duration of 90 minutes. It is validated as the above exam.

Steps Involved in this Certification

  1. Training: Oracle Database: SQL introduction:Program with PL/SQL: SQL Workshop I: SQL and PL/SQL Fundamentals
  2. Exam: pass either of these exams
    • 1Z0-047 Oracle Database SQL Expert or
    • 1Z0-051 Oracle 11g Database SQL Fundamentals I or
    • 1Z0-147 Oracle Database 12c SQL Fundamentals
  3. Exam: pass one of these exams
    • 1Z0-147 Program with PL/SQL
    • 1Z0-144 Oracle Database 11g: Program with PL/SQL
  4. Form: Complete the course submission form

For those wishing to advance in this certification to become Oracle Advanced PL/SQL Developer Certified Associate professionals; steps involved

  1. Training: Oracle Database 11g; Advanced PL/SQL
  2. Prior certification; Oracle PL/SQL Developer certified Associate
  3. Exam: Pass Oracle 11g Advanced PL/SQL 1Z0-146
  4. Form: complete the course submission form

The steps do not have to be completed in the order of sequence as listed. However one is required to complete all the steps before submitting the course registration form.

Validity of certification:

Valid lifelong

Expert Review

Technology has changed in the whole world and competition in the technology sector has risen. With Oracle PL/SQL Developer Certified Associate certificate you are assured of jobs and salary increments.

Mireille, Albemarle Corp

Machida, Japan.

Frequently Asked Questions

How can I get the products after purchase?

All products are available for download immediately from your Member's Area. Once you have made the payment, you will be transferred to Member's Area where you can login and download the products you have purchased to your computer.

How long can I use my product? Will it be valid forever?

Test-King products have a validity of 90 days from the date of purchase. This means that any updates to the products, including but not limited to new questions, or updates and changes by our editing team, will be automatically downloaded on to computer to make sure that you get latest exam prep materials during those 90 days.

Can I renew my product if when it's expired?

Yes, when the 90 days of your product validity are over, you have the option of renewing your expired products with a 30% discount. This can be done in your Member's Area.

Please note that you will not be able to use the product after it has expired if you don't renew it.

How often are the questions updated?

We always try to provide the latest pool of questions, Updates in the questions depend on the changes in actual pool of questions by different vendors. As soon as we know about the change in the exam question pool we try our best to update the products as fast as possible.

How many computers I can download Test-King software on?

You can download the Test-King products on the maximum number of 2 (two) computers or devices. If you need to use the software on more than two machines, you can purchase this option separately. Please email support@test-king.com if you need to use more than 5 (five) computers.

What is a PDF Version?

PDF Version is a pdf document of Questions & Answers product. The document file has standart .pdf format, which can be easily read by any pdf reader application like Adobe Acrobat Reader, Foxit Reader, OpenOffice, Google Docs and many others.

Can I purchase PDF Version without the Testing Engine?

PDF Version cannot be purchased separately. It is only available as an add-on to main Question & Answer Testing Engine product.

What operating systems are supported by your Testing Engine software?

Our testing engine is supported by Windows. Andriod and IOS software is currently under development.


PDF Version of 1z0-071 Questions & Answers

PDF Version

Now you can practice your study skills and test your knowledge anytime and anywhere you happen to be with PDF Version of your 1z0-071 exam.

Questions & Answers Questions & Answers PDF Version file has an industry standard file format .pdf. You can use any .pdf reader application like Adobe Acrobat Reader or many other readers to view your PDF file.

Printable 1z0-071 Questions & Answers PDF Version gives you comfort to read at leasure without using your computer or gadget.

* PDF Version cannot be purchased without the main product (1z0-071 Questions & Answers) and is an add on.

Money Back Guarantee

Test-King has a remarkable Oracle Candidate Success record. We're confident of our products and provide a no hassle money back guarantee. That's how confident we are!

Total Cost: $194.97
Bundle Price: $149.98

Purchase Individually

1z0-071 Bundle

Oracle 1z0-071

3 Products

1z0-144 Bundle

Oracle 1z0-144

2 Products


Download Free Oracle 1z0-071 Testing Engine Demo

Experience Test-King Oracle 1z0-071 exam Q&A testing engine for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your Oracle 1z0-071 exam.

  • Customizable, interactive testing engine
  • Simulates real exam environment
  • Instant download
Email Address
You will use this to log in to your account
* Our demo shows only a few questions from Oracle 1z0-071 exam for evaluating purposes

WINTER SALE! 15% Discount for All Exams!

This is a ONE TIME OFFER. You will never see this Again

Instant Discount
Test-King Testing Engine

15% OFF

Enter Your Email Address to Receive Your 15% OFF Discount Code Plus... Our Exclusive Weekly Deals

A confirmation link will be sent to this email address to verify your login.

* We value your privacy. We will not rent or sell your email address.


Your 15% Discount on Your Purchase

Save 15%. Today on all IT exams. Instant Download

Test-King Testing Engine

Use the following Discount Code during the checkout and get 15% discount on all your purchases:

Start Shopping