OCP 8i - SQL, PL/SQL - any tips?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: OCP 8i - SQL, PL/SQL - any tips?

  1. #1
    Hi Friends,

    I am doing my OCP first paper in two days. I've read the exam cram book and done all the tests in the book and also done all sample tests from

    http://www.selftestsoftware.com/demo...sp?demo=oracle - Test Demo questions.

    http://www.examcram.com - Test Demo questions, Also mailing lists with one question each day and answer for the previous day's questions (both in practice mode and real mode) - some tables might not be visible which makes it difficult to answer questions.

    http://www.sure.org.ru/docs/database/ocp/html/index.htm - Test Demo questions (both in practice mode and real mode) - sometimes correct answers are marked wrong, this can be checked out if you review the wrong answers.

    http://cramsession.brainbuzz.com/ - Another site with more tests, study guides, etc.

    http://www.examsonline.com - Free sample tests.

    http://www.cert21.com/free-practice-...dc26830590e977 More Free Tests

    http://www.dbasupport.com/oracle/cert/dba/ - Has questions with answers (not a test and no explanations).

    http://www.geocities.com/andre_nasser/tests.html - a Personal web site with a few sample questions and answers.

    http://www.chinaitcertify.com/en/demo.html Free questions.

    http://www.boson.com/tests/dba.htm Free sample questions.

    http://uk.geocities.com/shyamis/8SQL_PL.pdf - Cramsession Exam notes (pdf file) For SQL & PL/SQL..

    http://uk.geocities.com/shyamis/oracle.pdf - PDF file with questions and answers (study guide) For SQL & PL/SQL.

    http://www.oraclenotes.com/cgi-local...?ubb=forum&f=1 - Oracle Certified professionals forum.

    http://www.freetechnicaltraining.com/oracle/free_ocp/ - Free Technical training with power point presentations.

    http://www.brainbench.com/ - Used to have free tests, now there are no free Oracle tests! They have one free RDBMS test though!

    and Measure up as well. Nearly 380 questions. Can anyone tell me what else I will have to prepare from. I am having trouble opening the trial version of SYBEX. And what is ILT?

    Thanks,
    -S




  2. #2
    Join Date
    Jan 2002
    Posts
    57
    ILT is Instructor Lead Training. ILT manuals come from the Oracle training classes.

    --
    Paul

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Shyamis,
    Have you read one book.
    Be it sybex or couchman or ..
    If you have, you don't have to worry about the exam.
    because eventually the practice test will tend to get glued on to you, and don't expect any similarity in the exam.

    All the best........

    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Thanks Guys, can anyone tell me what do the questions mostly focus on, as in do they concentrate around DML/DDLs etc or around Database Dictionary and Processes or generally PL/SQL. Also what sort of PL/SQL questions are asked?

    Thanks in advance,
    -Shyami

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Actually all of it but like i said in the other post
    concentrate on trick questions in..
    pl/sql block,nested block, faulty assingnment operator within a block...meaning using dot notation instead of subset etc.
    in the sql...
    just watchout for subqueries ,especially mutliple row subqry..etc...
    pairwise/non pairwise,..
    That's why i asked if you've read one book because then you can always go back to topics to really understand them.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  6. #6
    Join Date
    Jan 2002
    Posts
    57
    In addition to what Tarry said, make sure you can walk
    through the logic of IF statements and loops.

    Some thing like:
    Given this IF statement:
    IF x > 90 THEN
    y := 'X'
    ELSE
    IF x > 85 THEN
    y := 'Y'
    ELSE
    IF x > 60 THEN
    y := 'Z'
    ELSE
    y := 'N'
    END IF
    END IF
    END IF

    What value(s) of x will give y a value of Z?
    60 < x <= 85

    OR
    Given the following PL/SQL block:
    BEGIN
    FOR i in 1..5 LOOP
    IF i=2 OR i=4 THEN
    commit;
    ELSE
    INSERT INTO t1(x) VALUES (i);
    END IF
    ROLLBACK
    END LOOP
    COMMIT
    END;

    How many values will be inserted into the t1 table?
    0

    I just made these question up. They are not actual questions
    from any source that I know of.

    --
    Paul

  7. #7
    Thank you friends! I read the Exam Cram book so I can check back on stuff! Hopefully will pass the exam with a good score. Thanks a million. Will keep you guys updated!

    Have a nice day,
    -Shyami

  8. #8
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    All the very best, shyamis!!!
    Crack it!!

    Tarry
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  9. #9
    Join Date
    Jan 2002
    Posts
    19
    Good Luck!!

    I just passed this exam 2days ago. Some questions were tricky as Tarry mentioned like sub queries,multiple sub queries and PL/SQl blocks.

    Let us know how you did it.


  10. #10
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    few questions i got

    Last edited by prodadmin; 09-02-2003 at 04:34 PM.

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