Regarding Study guide for 1Z0-007

[josephkarthic]

Hi tim,

I have decided to take the 9i DBA OCA/OCP cert, But im still in a confusion whether to take 10g or 9i, anyways to start with Can u pls suggest me the best book for the exam 1Z0-007? right now im reading Nancy Greenburg/ Priya Nathan's 'Introduction to Oracle 9i SQL" book, is it good for 9i DBA OCA?

Also pls tell me,

1)How to practice oracle sql query and the things i come across the book? Are thr any tool to work out and practice it in home? I see a tool called "sql developer" in oracle website...Will tht help me to practice as of now? or is thr a better tool than tht?

2)And, do tht do we need to install Oracle database?

Im asking this just to have a hands on approach while studying as it will help me in my oracle job when i get one..

[Tim...]

Hi.

Regarding the product versions. Take the OCP track for the version of the database you are most likely to use. Oracle 9i is still very popular, so it does no harm in getting that certification, but equally, I see no problem in going straight for 10g certification.

As far as study guides go, the Sybex ones are considered the best by most people I speak to:

http://www.oracle-base.com/books/BookDe ... dy%20Guide

To answer your other questions:

1) You can use SQL Developer or SQL*Plus to practice SQL, provided yo have a database to connect to.

2) You definitely need download the Oracle software and install it. You might pass the exam without using Oracle, but your OCP will be useless unless you have actually used the software. You need to practice everything in the study guides and get a feel for the product.

Cheers

Tim...

[josephkarthic]

Thats exactly what im gonna do... Ofcourse tim the reason we do cert is to know the product better and only with tht knowledge we can work so im gonna practice, by the way sql*plus is a free tool ? if so whr can i get it?

And i will ask some more ques if i have doubts in installing oracle and stuff like tht...

Also Just to let u knw, the 'books' section under 'misc' tab has some errors in displaying search results, whn u click the 2nd or 3rd page it shows some error like this..

"Warning: file(http://ecs.amazonaws.com/onca/xml?Servi ... ...........

I still wonder how did u get tht book link by searching in the bookstore link

[Tim...]

Hi.

SQL*Plus is a command line tool that comes with the Oracle database and client. If you install the database, you have SQL*Plus.

I got the book link off my certification page:

http://www.oracle-base.com/misc/ocp-certification.php

Cheers

Tim...

[josephkarthic]

Ok thankyou,

Also if i take 10g path will be able to know the basics too? coz im just a fresher to oracle so i wonder whether 10g may be advanced and i wud find difficult in work if i dont do 9i, is tht the case? If we can take 10g wht abt 11g then?? can we take tht instead of 10g?

[Tim...]

Hi.

10g and 11g are easier to use than 9i. Oracle keep trying to make the products easier with each release. You will find the 10g certification easier than the 11g certification. Which ever certification you do, you can do the upgrade exams to move to the next version.

Cheers

Tim...