7 Replies Latest reply: May 20, 2011 5:17 AM by 75407 RSS

    Oracle 11g Advanced PL/SQL 1Z0-146

    850919
      Oracle 11g Advanced PL/SQL 1Z0-146 - Oracle Advanced PL/SQL Developer Certified Professional - OCP

      Hi,

      I completed OCA (1Z0-007 and 1Z0-147).
      Now, I want to go for OCP (1Z0-146).
      Is it mandatory to have a training for some time period (say 1 month) before appearing for this exam?

      Please let me know what all are the prerequisites to appear for OCP (Oracle 11g Advanced PL/SQL 1Z0-146)?

      Thanks!

      Regards,
      Vijay Inani
        • 1. Re: Oracle 11g Advanced PL/SQL 1Z0-146
          568526
          no training needed. just go take the test when you're ready.
          • 2. Re: Oracle 11g Advanced PL/SQL 1Z0-146
            661723
            hi

            i was doing OCA pl/sql training in 10g lots back w/o WDP.
            can you give me a guideline for 1z0-147 exam??

            kind regards
            • 3. Re: Oracle 11g Advanced PL/SQL 1Z0-146
              568526
              There's a practice test & study guide you can get from SelfTest here:
              http://www.selftestsoftware.com/product.aspx?product_id=1Z0-147&dept_id=6024

              I didn't have to take that test myself, having taken an older version of it, 1z0-101.
              • 4. Re: Oracle 11g Advanced PL/SQL 1Z0-146
                661723
                Dan T wrote:
                There's a practice test & study guide you can get from SelfTest here:
                http://www.selftestsoftware.com/product.aspx?product_id=1Z0-147&dept_id=6024

                I didn't have to take that test myself, having taken an older version of it, 1z0-101.
                Continue Shopping at Oracle9i Developer Associate Exams Practice Tests (2 Tests Required)
                its on 9i.
                • 5. Re: Oracle 11g Advanced PL/SQL 1Z0-146
                  MichaelMilligan,President,BiomedAnalytics
                  Just a heads up - I have certifications in Oracle 9i Database Administrator OCP,  Oracle Advanced PL/SQL Developer OCP, and Oracle Database SQL Certified Expert, so I've taken my share of difficult Oracle exams. 1Z0-146 was the most difficult exam I've taken so far. I passed, but I was sweating bullets.

                  Know the material well and practice it, too. The best preparation for this exam IMHO is the Oracle documentation. I printed out the relevant parts of the documentation PDFs then studied, and highlighted, and studied more, and took notes in my own words, and practiced in SQL Developer.

                  Good luck!
                  • 6. Re: Oracle 11g Advanced PL/SQL 1Z0-146
                    raoul
                    So it is just looking at the topics and searching the oracle documentation for it?
                    I would find usefull information to help me learn the advanced plsql and pass the exam?
                    • 7. Re: Oracle 11g Advanced PL/SQL 1Z0-146
                      75407
                      raoul wrote:
                      So it is just looking at the topics and searching the oracle documentation for it?
                      Looking at the topics is perhaps too passive .... researching the topics is perhaps a more accurate description.

                      The oracle documentation will almost certainly contain the information. However sometimes other sources (eg aforementioned books) might provide additional insight.

                      IMHO It is then necessary practice and makes notes / flashcards on what has been found.
                      I would find usefull information to help me learn the advanced plsql and pass the exam?
                      Yes. Surprising as it is IMHO Oracle really does try to document PL/SQL so people can use it!

                      Though sometimes appreciating the appropriate scope of a question may be difficult.

                      Edited by: bigdelboy on 20-May-2011 03:02 (Good other sources would include http://asktom.oracle.com ; {forum:id=75} (with care .. sometimes stupid a answers can be made .. others will be gems) ...
                      :: http://www.oracle.com/technetwork/index.html .. Learning Library .. http://www.oracle.com/technetwork/articles/sql/index.html ... etc. Part of a good cerification journey is to search out and find these resources!