Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

OCA 1Z0-007 Mockup exam

 
VAruna
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 39
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here's one exam/set of practice questions:

http://www.qod.us/Oracle-1Z0-042-exam.htm
 
Nicholas Cheung
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 39
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How do you get notified for beta's?
 
Nicholas Cheung
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
From Oracle's website: http://www.oracle.com/education/certification/index.html

Nick
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic