OCA 1Z0-007 Mockup exam

[VAruna]

Hello there ! Any idea about free mockup exam for Oracle 1Z0-007 exam ?
Also ,
What are the 2 exam for OCA ?? 1Z0-007 & ??

Thanks & Chao, Aruna

[Nicholas Cheung]

What are the 2 exam for OCA ?? 1Z0-007 & ??

1z0-007 and 1z0-031

In fact, Oracle10g OCA just require 1 exam: 1z0-042 and this exam is currently in beta status, why dont you consider it?

Nick

[VAruna]

Gee thanks Nick !
I am new to this. Could you please help me with the following ?
1. Good books for 1z0-042 ?
2. Reference sites ?
3. Free Mockup sites if any ?

Thanks, Aruna
[ September 24, 2004: Message edited by: VAruna ]

[Nicholas Cheung]

1. Good books for 1z0-042 ?

No.
The only resource is the technical manual from Oracle site.

2. Reference sites ?

The Oracle TechNet.

3. Free Mockup sites if any ?

Of course not. There are even very few resources on Oracle 8i/9i. And 10g is even less, if not none.

Nick

[Rishi Ugersain Chopra]

Here's one exam/set of practice questions:

http://www.qod.us/Oracle-1Z0-042-exam.htm

[Nicholas Cheung]

I am a bit wonder on the sample test. Its subscription fee is quite high, however, there are only 100 questions in the pool. Moreover, 1z0-042 does not release yet, even if they took the beta exam 1z1-042, there should be 170+ questions, how similar the questions to the real thing is still one of my concerns.

In addition, they also provide 1z1-043 questions, however, the exam is even NOT in beta status.

Nick

[Rishi Ugersain Chopra]

Sorry, I didn't realize that was a pay site!

My advice would be to look for sample questions to the 9i SQL (#1Z0-007) and 9i Administration I (#1Z0-031) tests, then sign-up to take the 10g (#1Z0-042) test. The differences between 9i and 10g are small and there's definitely a cost benefit between two tests (~$250+) to one test (~$125+).

There's an abundance of free questions for 8i and 9i, and many of the basic concepts have not changed (notable exceptions is OMF).

[Nicholas Cheung]

The differences between 9i and 10g are small and there's definitely a cost benefit between two tests (~$250+) to one test (~$125+).

In addition to the cost difference, 10g provides more new features in the questions, such as Flashback query and transaction, Recycle bin, Enhanced Block Recovery, etc. You might find the questions a bit more chanllenging than 9i.

Nick

[Shiang Wang]

Here is some documentation I found in Oracle website
Oracle 9i SQL Reference online documentation
Oracle 9i PL/SQL User's Guide and Reference
Oracle9i Application Developer's Guide - Fundamentals
Oracle9i Database Concepts

IMHO, these are more than enough to take care of SQL and PL/SQL exams. I like Oracle Concepts a lot, it gives you an overall Oracle database architecture.
I admit this is a poor boy way to prepare for the exam - you have to map the objectives to the document. I only skimmed through the objectives and document, in case I miss something, here is Oracle9i Database List of Books

Hope this helps.
Shiang

[marco borsato]

How do you get notified for beta's?

[Nicholas Cheung]

From Oracle's website: http://www.oracle.com/education/certification/index.html

Nick