OCP Developer test no.2

[shimi123]

I'm perparing for my seconed exam and I Wanted to get tips for the exam.
And a question:
Shoul'd I learn by heart the built in ORACLE server packges?

Shimi.

[julian]

Shoul'd I learn by heart the built in ORACLE server packges?

Yes, with all the functions and procedures within plus the parameters they accept. And don't forget also the default values of those parameters :-)

Of course, you shouldn't do that. I was pulling your leg :-)

[shimi123]

Now seriously any tips?
Shimi.

[julian]

Originally posted by shimi123
Now seriously any tips?
Shimi.

By 2nd exam, you mean the PL/SQL one, right?
The questions are tricky, not difficult. Check again that you know everything about packages, the things about packages that you do not do in everyday programming: overloading, global variables in packages (what happnes when it is in the specification and when it is in the body). Read again the things about dependencies! You might get several questions on packages, so you might find them the most difficult ones, who knows. Do not spend much time on reading the long codes. Read the question first and then the code.

I had the feeling that the exam is made for people with practical experience on PL/SQL.

Wish you best of luck!

[shimi123]

I'll keep it in mind!

[dknight]

I had the feeling that the exam is made for people with practical experience on PL/SQL.

This exam is challenging. You should write a lot of code and think about the problems you might encounter as a PL/SQL Developer.

For example triggers and mutating tables, compiling packages, status of packages, and so forth.

I passed this test in August, 2000, using Couchmans book, but it was very difficult.

Good luck.

[julian]

I passed this test in August, 2000, using Couchmans book, but it was very difficult.

I agree. I think it is probably the most challenging exam of all 1Z0-XXX exams.

[shimi123]

even tough there is not a lot of metitial the question are ment to be confusing?
Witch mean studing the small issues?

[julian]

Witch mean studing the small issues?

Yes. Small issues that a not everyday's PL/SQL programmer's problems. I remeber I got a question on the init.ora file. As a DBA I knew the answer. But when I was a PL/SQL developer I even didn't know what an init.ora is :-)