Regarding Oracle9i OCA

Ranch Hand

Posts: 232

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 4982

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 232

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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?

SCJP ,SCWCD

Nicholas Cheung

Ranch Hand

Posts: 4982

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 8

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

He puts the "turd" in "saturday". Speaking of which, have you smelled this tiny ad?

Smokeless wood heat with a rocket mass heater

https://woodheat.net