jQuery in Action, 2nd edition*
The moose likes Product and Other Certifications and the fly likes Regarding Oracle9i OCA Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Certification » Product and Other Certifications
Bookmark "Regarding Oracle9i OCA" Watch "Regarding Oracle9i OCA" New topic
Author

Regarding Oracle9i OCA

Rohitt Vermaa
Ranch Hand

Joined: Oct 12, 2006
Posts: 232
Hi, I am Java Programmer. I want to get certified in Oracle. Oracle is new to me. I searched previous threads in this forum. But i still have some queries. Anyone please clarify and correct me if I am wrong.
1. I will take the Introduction to Oracle9i:SQL(1Z0-007) exam first via Internet and then take Oracle9i Database: Fundamentals I(1Z0-031). Am i right about this.

2. Which book should i refer or which book covers the certification objective completely.
OCA Oracle9i Associate DBA Certification Exam Guide Jason S. Couchman, Sudheer N. Marisetti or
OCA/OCP: Oracle9i DBA SQL Study Guide Chip Dawes, Biju Thomas & OCA/OCP: Oracle9i DBA Fundamentals I Study Guide Biju Thomas, Bob Bryla

3. How much time will it take to complete the 1st and 2nd exam provided I am new to Oracle and will dedicate 20 hours/week for the study?

4. Is there any other materials I should refer.

Thanks in advance for your replies.


SCJP ,SCWCD
Nicholas Cheung
Ranch Hand

Joined: Nov 07, 2003
Posts: 4982
1. I will take the Introduction to Oracle9i:SQL(1Z0-007) exam first via Internet and then take Oracle9i Database: Fundamentals I(1Z0-031). Am i right about this.

Yes. However, the order of exam sequence will not affect the certified process.


2. Which book should i refer or which book covers the certification objective completely.
OCA Oracle9i Associate DBA Certification Exam Guide Jason S. Couchman, Sudheer N. Marisetti or
OCA/OCP: Oracle9i DBA SQL Study Guide Chip Dawes, Biju Thomas & OCA/OCP: Oracle9i DBA Fundamentals I Study Guide Biju Thomas, Bob Bryla

I used the ILT materials distributed by Oracle University. The exam questions are very similiar to the content, and some of them even exactly the same.


3. How much time will it take to complete the 1st and 2nd exam provided I am new to Oracle and will dedicate 20 hours/week for the study?

1z0-007 is quite easy, I used approximately 10 hours to study. 1z0-031 is a bit difficult, but if you have database system knowledge, it should be easy to tackle. I spent around 20 hours for this exam, provided that I have taken some database system courses during undergraduate days.


4. Is there any other materials I should refer.

For me, ILT materials are my only reference.

Nick


SCJP 1.2, OCP 9i DBA, SCWCD 1.3, SCJP 1.4 (SAI), SCJD 1.4, SCWCD 1.4 (Beta), ICED (IBM 287, IBM 484, IBM 486), SCMAD 1.0 (Beta), SCBCD 1.3, ICSD (IBM 288), ICDBA (IBM 700, IBM 701), SCDJWS, ICSD (IBM 348), OCP 10g DBA (Beta), SCJP 5.0 (Beta), SCJA 1.0 (Beta), MCP(70-270), SCBCD 5.0 (Beta), SCJP 6.0, SCEA for JEE5 (in progress)
Rohitt Vermaa
Ranch Hand

Joined: Oct 12, 2006
Posts: 232
Thanks Nicholas. Thank you very much. Also anyone please clarify me about the 007 exam. In the Official Website it is given as 007 can be taken via internet. Can we take this exam from home?
Nicholas Cheung
Ranch Hand

Joined: Nov 07, 2003
Posts: 4982
Can we take this exam from home?

Yes, you can do it at home or office or anywhere that having Internet connections. If you wish, you can even complete the test in an open book manner! But I would not suggest you to cheat during the test.

Nick
arpita singh
Greenhorn

Joined: Oct 08, 2010
Posts: 8
may i know when during the year can i give the oca 9i certification exam and are there any freely downloadable study materials for it???plzzzzzzz help me out
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regarding Oracle9i OCA