PLSQL Program Units 101

Greetings,

Thanks to all for the help and advice.

I cleared my second exam an hour ago. (49/57). It was much more difficult than I expected.

I was using Couchman's developer's guide for this exam and the breakup of questions was different in the exam. In the exam it was

Creating Procedures 8
Creating Functions 8
Creating Packages 8
More Packages Concepts 6
Oracle supplied Packages 6 (Four questions on Dynamic SQL)
Creating Database Triggers 7
More Trigger Concepts 5
Managing Subprograms and Triggers 5
Managing Dependencies 7.

My mistake, I was using the 1999 version of STS and found that the actual exam was totally different than the STS.

Around 6 questions had the options to choose 2 or 3 answes.

Surprisingly one question was repeated twice :)

--OCP IP.

Good for you ... which developer track are you working on?

Gee

Congratulations

I am a certified DBA in 8 and 8i and I am starting my developers track. Did you find the Couchman book prepared you well enough for the exam. I am trying to decide what study materials I should use seeing how my company is too cheap to pay for the Oracle courses.

I will be writing the last DBA exam next week. I then plan on moving onto the Internet Application Developer Track.

I have taken Julian's recomendation and have ordered the following book for the last 2 exams (131 & 132):

Oracle Certified Professional by Christopher Allen" ISBN 0072193336

I am still trying to figure out what resource to use to write the 101 exam ... any advice would be apperciated.

Gee

I am preparing for Rel2 (Core exam) as after clearing all the 5 exams you get two certificates OCP Application developer and OCP Internet Applications developer.

I had prepared using Couchman's guide and personal experience (3 years) but I have never written any code with Dynamic SQL. There was one more question about Triggers,

which parameter do you set to maximize the number of triggers on database. (Never heard of any thing like this in my development career).

I will suggest if you can wait for another exclusive release of Couchman's book for Program units exam. May be that has the new structure and concepts. I used 1999 edition.

There was no question on Procedure builder as described in the book. Also local subprograms in the procedures are not discussed in the book but there were atleast 5 questions in the exam.

STS are nodoubt a great help.

HTH,

--OCP In Progress. :)

Quote:

---

Originally posted by OCPIP

STS are nodoubt a great help.

HTH,

--OCP In Progress. :)

---

What questions did you get? Could you be more specific by pointing out the difficult questions. What sort of dynamic SQL questions did you get?

Are you talking about the second exam of 'Database Administration' ?

julian>>>

What questions did you get? Could you be more specific by pointing out the difficult questions. What sort of dynamic SQL questions did you get?


OCP IP >

Some of the questions that I remember are ,

1. What is the function of Parse in Dynamic SQL.
2. What is the function of Execute in Dynamic SQL.
3. One trigger question as mentioned below in my previous mail.
4. User wants to compile all program units at one time in PL/SQL. What command can the user use.

Some direct questions relating to Packages, Procedures, Functions and Triggers were there which were simple.


HTH,

OCP IP.

anajli,

talking about second exam for developer track.

Gee

Quote:

---

Some of the questions that I remember are ,

1. What is the function of Parse in Dynamic SQL.
2. What is the function of Execute in Dynamic SQL.
3. One trigger question as mentioned below in my previous mail.
4. User wants to compile all program units at one time in PL/SQL. What command can the user use.

---

1. dbms_sql.parse ?
2. dbms_execute ?
3. MAX_OPEN_CURSORS ?
4. exec dbms_utility.compile_schema ?

Please read purpose instead of function in the first two questions.