PLSQL Program Units 101
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: PLSQL Program Units 101

  1. #1
    Join Date
    Aug 2001
    Location
    Manchester, UK
    Posts
    86

    Talking

    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.


    -- Anurag.
    OCP Application Developer
    ---------------------------------------------------------
    "Be not afraid of growing slowly. Be afraid only of standing still."

  2. #2
    Join Date
    May 2001
    Location
    Victoria, BC Canada
    Posts
    183
    Good for you ... which developer track are you working on?

    Gee

  3. #3
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    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.

    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  4. #4
    Join Date
    May 2001
    Location
    Victoria, BC Canada
    Posts
    183
    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

  5. #5
    Join Date
    Aug 2001
    Location
    Manchester, UK
    Posts
    86
    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.
    -- Anurag.
    OCP Application Developer
    ---------------------------------------------------------
    "Be not afraid of growing slowly. Be afraid only of standing still."

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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?


  7. #7
    Join Date
    Oct 2001
    Posts
    38
    Are you talking about the second exam of 'Database Administration' ?

  8. #8
    Join Date
    Aug 2001
    Location
    Manchester, UK
    Posts
    86
    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.
    -- Anurag.
    OCP Application Developer
    ---------------------------------------------------------
    "Be not afraid of growing slowly. Be afraid only of standing still."

  9. #9
    Join Date
    May 2001
    Location
    Victoria, BC Canada
    Posts
    183
    anajli,

    talking about second exam for developer track.

    Gee

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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 ?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width