| |
|
Introduction to Oracle: SQL and PL/SQL
| Exam
Facts: 1Z0-001 |
 |
|
Passing
Score:
|
39,
68% |
| Questions: |
57 |
| Test
Type: |
Online
and Proctored |
| Format: |
Multiple
Choice |
| Time
Allotted: |
120
minutes |
| Certifications: |
All
Oracle Certified Professional Tracks |
| Study
Brief: |
Online
format |
| Feedback: |
Oracle
Certified Professional Forum |
| |
|
| Topics
To Know |
|
| By Don
Farland,
Oraclenotes.com |
The
Introduction to Oracle exam is the keystone of the
Database Administrator OCP program. Whether you are
pursuing certification in versions 7.3, 8, or 8i, the
foundation of the Oracle RDBMS is firmly rooted in
the SQL and PL/SQL languages. If you want to get through
this certification as painlessly as possible you will
have to learn the information covered in this exam.
This information comes from four distinct categories:
SELECT statements, data manipulation, object creation,
and basic PL/SQL.
This
test can be very unforgiving if you don't know your
stuff. The majority of the questions on the exam will
provide a statement and an exhibit where you will either
be asked to identify the line that is malformed or
the outcome of the statement. This is never more apparent
than in the examples using mismatched comparison operators,
violated integrity constraints, and mixed single-group
functions. Review the exhibits carefully and parse
each statement in your head to avoid making what will
surely amount to a careless mistake. The rest of the
questions will generally take a more "direct" approach,
with questions that ask you to identify the benefits
or behavior of a particular structure or keyword. You
will also be tested on the correct use of GROUP functions,
the HAVING clause, and the utilization of runtime variables.
In addition, you will definitely receive a couple of
questions on joins, especially outer and self-joins.
Be
sure you are familiar with the various stages of database
design. You are sure to get a couple of questions about
Entity-Relationship Diagrams and the stages of system
development. Also expect numerous questions about DML,
DCL, commits, and rollbacks. Object creation seems
to take a back stage in this exam, but expect a couple
of questions each for tables, indexes, constraints,
sequences, and views. The final three will probably
seem to get the most attention, make sure you know
the rules governing the utilization of all three objects.
While
it may seem that PL/SQL is a "back burner" topic in
this exam it is definitely not the case. PL/SQL accounts
for approximately 20% of this exam and has the potential
to severely hamper your efforts to pass. The most important
aspects to be familiar with are process flow, cursors,
and loops. These areas will draw the most attention,
but expect a few questions on block constructs, exception
handling, and variable assignments.
The
key to passing this exam is being thorough. Your worst
enemy is your own carelessness. Read the question carefully,
then read ALL the answers. Unless you are absolutely
certain of the answer, reread the question and answers
again and then begin the selection process. Try to
rule out the absurd answers the first time through.
Surprisingly, this can sometimes eliminate all of the
answers except for the correct one. Make sure to take
advantage of the MARK feature. Mark any question you
are unsure. Sometimes a later question will trigger
something in your memory and having marked the question
will make it easier to locate later.
Good Luck!
|
|
