my dog learned polymorphism*
The moose likes Oracle/OAS and the fly likes Passed 1Z0-007 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Passed 1Z0-007" Watch "Passed 1Z0-007" New topic
Author

Passed 1Z0-007

Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

I passed the Intro to SQL 9i test last night.
Scored 54/57 94.7%
1 down three to go.
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Remar Uy
Ranch Hand

Joined: Mar 18, 2002
Posts: 35
Congratulations Mark!
girish rateshwar
Ranch Hand

Joined: Mar 04, 2001
Posts: 97
Congrats Mark.
Well even im planning to appear for the next exam (1z0-031). Could you let me know as to what study materials have u been using?
Regards,
Girish S R


Girish
Sumit Amar
Ranch Hand

Joined: Jun 08, 2002
Posts: 180
Congratulations Mark! Great start, I hope you'll keep up the good score. All the best for rest of the exams.


SCJP, SCWCD, OCA, OCP-DBA 9i, <a href="http://brainbench.com/transcript.jsp?pid=2232802" target="_blank" rel="nofollow">BCIP</a>, MCP, MCAD, MCSD.NET, MCDBA, MCTS (SQL 05), MCITP (DBD, DBA)
girish rateshwar
Ranch Hand

Joined: Mar 04, 2001
Posts: 97
Hey sumit,
Could u le me know as to wat resources did u utilise for your prep for 1z0-031.
Apart from practicals, any mock tests on the net?
Did u buy the one from whizlabs?

Regards,
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

Girish.
I am taking all the DBA classes at UC-Irvine Extension.
So I have the Oracle materials. I also bought the self-test software to take practice exams.
I think their website is http://www.stsware.com
Good Luck
Mark
ananth duggs
Greenhorn

Joined: Dec 17, 2002
Posts: 4
hi all, I'm planning to take the Oracle Certification to become an OCA..I just picked up Oracle but I do have some database and SQL experience...I'm totally new to Oracle and have to start from scratch..Could you tell me how much time it will take to become an OCA?? Could you also tell me what books I should be reading and whether it is really important to buy the software from SelfTest...I am planning to buy the book
OCA/OCP : introduction to Oracle9i SQL study guide / Chip Dawes, Biju Thomas
Could you tell me how useful this book was to anyone who bought it..I would really appreciate it and thank you for your time to give me this information.
Thanks again
Ananth
girish rateshwar
Ranch Hand

Joined: Mar 04, 2001
Posts: 97
Hi mark,
Thanks for the tip. Well ananth , the book by biju thomas is def worth buying.
But i presume if u cud have the kit from oracle university which is the most comprehensive study material for getting certified.
Subscribe to the OTN site for the oracle magazine.
http://www.oracle.com/oramag/
Regards,
ananth duggs
Greenhorn

Joined: Dec 17, 2002
Posts: 4
Hi Girish,
Thanks a lot for your valuable comments..I'm planning to buy the book by Biju Thomas but I was'nt very sure where to find the kit at Oracle University. Could you please show me the link... I'm sorry abt that.. And also could you please tell me how much time you think it will take me to complete the first exam...
Thank you
Ananth
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

ananth, try finding the Oracle materials on EBay. I hear that you can find them there sometimes. But it might be costly, because Oracle sells them for the entire price of the class. They won't sell them seperately. But I heard they are about a $200 value for each class.
Mark
ananth duggs
Greenhorn

Joined: Dec 17, 2002
Posts: 4
Thanks Mark, I'll chech out Ebay now and see if I can find anything...and yeah CONGRATS for scaling the first exam..I hope to reach that spot soon.. Thanks again
Ananth
Praveen Zala
Ranch Hand

Joined: Jul 02, 2000
Posts: 118
Folks ...
Can you give me some sites where I can try to do a few sample tests ....
Regards,
Praveen
Remar Uy
Ranch Hand

Joined: Mar 18, 2002
Posts: 35
Try http://www.oracle.com/education/certification/index.html?sts.html
Hth.
Remar Uy
Ranch Hand

Joined: Mar 18, 2002
Posts: 35
TrySTS.
I messed up the previous post.
sameer_mca
Greenhorn

Joined: Aug 02, 2002
Posts: 5
I have cleared exam 1z0-007 and now preparing for exam 1zo-031. I am having Oracle press and Sybex book. I am also having ILT. I need some more material and test. I am a student. Please help me.
my email :- sameer_mca@rediffmail.com
Sumit Amar
Ranch Hand

Joined: Jun 08, 2002
Posts: 180
Girish and other 031 aspirants, 1Z0-031 was just a hype , nothing else and I got 90% . As for Whizlabs 031 Mock Exams, you can try their trial version for free and then buy a full version in late december. Also you can try cert21.com's free 40 questions on 031 test. Another 18 free questions from STS. (dbdomain.com). So you can grab 88 free questions instantly, these will give you an idea , what level of questions are asked in the exam.
all the best.
[ December 23, 2002: Message edited by: Sumit Amar ]
sonny kher
Ranch Hand

Joined: Nov 06, 2001
Posts: 83
I was reviewing the demo questions at cert21.com and some of the questions seem like they are not part of the actual test objective. There are questions on
1. Tablespace
2. Datafile
3. Drop function command
Are these topics part of the real test?
-sonny


_ __________________ _ <br />RHCE<br />SCJP<br />??:-(
Yousef99
Greenhorn

Joined: Jan 02, 2003
Posts: 4
Hi all, Happy new year..
I am planning to do 1Z0-007 exams, I really confused. I had an official Oracle material, which are from Oracle University? Are they sufficient for the exam? Plus that, can you recommend to me the best free self-test software or any bdf materials. Please give me the exact link for the software of the bdf file because when I tried the above links I really get lost. Are the bdf documents worth than the self-test software’s or not??
I appreciate your help many thanks in advance.


Thanks to you..
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

"Y M E"-
Welcome to the JavaRanch! Please adjust your displayed name to meet the
JavaRanch Naming Policy.
You can change it
here.
Thanks! and welcome to the JavaRanch!
Mark
girish rateshwar
Ranch Hand

Joined: Mar 04, 2001
Posts: 97
Hi sumit,
Indeed i found around 90 practice test questions from the links u gave me. I presume this test concentrates more on the new features in the ORACLE architechture.
So off to the exam. Will get bac.
Thanks
Yousef99
Greenhorn

Joined: Jan 02, 2003
Posts: 4
Thanks a lot Mark and this is my new nick name......Waiting the answer for my question!!
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

Yousef99
Actually the naming policy is that you have your real first name, and also your real last name. There are two fields in the screen.
I can't really help you on bdf files, but you can always search Yahoo. as far as free testing software, you can always download Demos of the testing software which will give you a few question. The Oracle U. Material is where every question comes from, if it is not in there then it won't be on the test.
Now my Oracle U. book was for 8i, so it didn't cover the Merge command, iSQLPlus. But everything else was there.
Thanks
Mark
John Lee
Ranch Hand

Joined: Aug 05, 2001
Posts: 2545
Congratulations!
Sumit Amar
Ranch Hand

Joined: Jun 08, 2002
Posts: 180
It's true that Cert21 is little off the hook!
ananth duggs
Greenhorn

Joined: Dec 17, 2002
Posts: 4
Hi Everyone,
I just passed IZ0-007..got 91%..one down, three more to go Could anyone give me guidelines and the needed books for the second exam. I would really appreciate it. Thanks.
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
I thought that the 2nd one was quite tough. Lot of "select the best 3 answers from the 7 options below.."
(I counted 26)
My advise is to read the oracle documentation
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/index.htm
Rather than spend money on books (with errors).
Simon
Vijaya Sharma
Greenhorn

Joined: Feb 02, 2003
Posts: 1
I have recently passed sql9i and the exam was good and passed it with okay marks.I studied the OCA/OCP,introduction to 9i from biju thomas and chip dawes,this book is more then enough for passing the exam but one needs to go through it very deeply.
I have to give oracle fundamental-I now please help me with good study material.i'll be really thankful
Vijaya
Vijaya_saphire21@hotmail.com
John Wetherbie
Rancher

Joined: Apr 05, 2000
Posts: 1441
Mark,
I have started looking into Oracle certifications. I noticed your comment about 1 down, 3 to go. I assume you are going for the DBA Certified Professional.
I have a few questions that the Oracle site can't, or doesn't seem to, address.
What do you know about the PL/SQL Developer cert? Does this cert make more sense than the DBA Associate for someone who is a developer?
Is there a data modeling cert or component of one of the other certs?
Thanks and congrats on passing the cert exam!


The only reason for time is so that everything doesn't happen all at once.
- Buckaroo Banzai
Deepa Janakiraman
Greenhorn

Joined: Jan 22, 2003
Posts: 22
I am reading the sybex book for 007. Do I really need to memorize the functions to pass the exam?
How often the function related questions appear on exam?
Thanks
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

John when I looked at the PL/SQL Developer Ceritifaction, it seemed to me to be leaning heavily towards Oracle Forms and Reports, which I don't want to do.
Now funny thing on that note. We currently have a consulting company rewriting our Purchasing System in Oracle Forms and Reports. It is going good, but I just don't see a huge market for Oracle Forms and Reports, there seems to be too many limitations, and the App Server is the biggest pain in the ^&$, to install, patch, and new releases make previous built forms not work and have porting issues. It has been a major nightmare.
That is why I chose the DBA role, even though I am a developer. On that note, the best course to take for a developer to code to Oracle is Thomas Kyte's book "One on One Expert" by Wrox publishers. Great information that you won't find anywhere else.
Mark
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

"Do I really need to memorize the functions to pass the exam? "
What functions do you mean? to_char()? If so yes.
Mark
HS Thomas
Ranch Hand

Joined: May 15, 2002
Posts: 3404
posted by Mark Spritzler:
John when I looked at the PL/SQL Developer Ceritifaction, it seemed to me to be leaning heavily towards Oracle Forms and Reports, which I don't want to do.

I passed this in 1999, but didn't think there was much of a future for it then, even though I had worked with it commercially.
Trying to design for re-usability in a PL/SQL package was tough.Tough? Did I say tough? I meant impossible.
That was when I decided to switch to Java and have stayed the course since.
Hope it pays off !
regards
Deepa Janakiraman
Greenhorn

Joined: Jan 22, 2003
Posts: 22
Hi guys I passed 007 with 91.2% yesterday.
Thank you all for the help.
Deepa
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

Congrats Deepa, great job.
Mark
Ruff Young
Ranch Hand

Joined: Sep 26, 2002
Posts: 513
Congratulations!


SCJP2, SCWCD<br />IBM Certified WebSphere<br />IBM Certified Solution Developer for WSAD
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

The Oracle material is documentation you can buy, or receive at Oracle certified trainors. It is not something that can be given away.
Please remove your post requesting it. I won't remove it myself, I thought you might like to.
Mark
p.s. There are sites on the internet that can really help you out.
D. Rose
Ranch Hand

Joined: Apr 25, 2003
Posts: 215
Hi,
I have purchased Biju Thomas book for 031. Can anybody, who has passed this exam, tell me whether this book is good enough for preparation?
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

"rdamle"-
Welcome to the JavaRanch! Please adjust your displayed name to meet the
JavaRanch Naming Policy.
You can change it
here.
Thanks! and welcome to the JavaRanch!
Mark
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

Have you checked in the Bunkhouse for a review, or on Amazon for their reviews. I think you can get some good ideas from there.
I haven't read the book, so unfortunately I can't help much there.
Good Luck on the test.
Mark
aadhi agathi
Ranch Hand

Joined: Apr 29, 2002
Posts: 263
hi Mark,
hearty congrats! quite surprising to see you here though!


Aadhi
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Passed 1Z0-007
 
Similar Threads
Passed, -:)
Passed
Passed
Passed