Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle9i inputs please

 
Ravi vv
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I need to prepare for Oracle9i Associate exam first before writing any others. Could some one help me with inputs?
Thanks in Advance
Ravi
--SCWCD
 
SJ Adnams
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
if you have more than a few years experience with SQL then the first exam should be a cakewalk.
I think the 2nd exam is the toughest (I've actually taken all the OCP exams but failed performance tuning, so need to take it again).
I'd recommend the sybex book and the oracle docs
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/index.htm
 
Ravi vv
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Lee,
I have almost 4 yrs experience in SQL. So first shouldn't be a problem I hope. I will try to write this week..
Are we going to receive any certificate from Oracle after the completion of first one or should we wait to complete both to get Associate?
Is there any links to practise tests for First exam
Ravi
 
Jack Yan
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I got ORACLE8i OCP DBA 2 years ago.
The first exam is very easy if you used PL/SQL for years.
how to prepare :
1)PL/SQL - user guide and reference
2)SQL*PLUS - user guide and reference
 
D. Rose
Ranch Hand
Posts: 215
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ravi,
I have passed first exam and preparing for second. I used sybex book by Biju Thomas and Chip Dawes for this.It was quite OK (a very long errata though!). Some questions are a bit tricky and you should know eaxct statement syntaxes.
I did not take any other tests etc. I think you can pass easily if you have SQL experience.
You get OCA certificate only after passing 2nd exam.
If you come across any other good resources for this certification, please let me know.
All the best!
[ May 01, 2003: Message edited by: rdamle ]
[ May 01, 2003: Message edited by: rdamle ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic