Oracle Certification announced on March 13 the retirement of several exams, including 1Z0-147: Program with PL / SQL. This exam meets the PL / SQL component to become an Oracle PL / SQL Developer Certified Associate. Originally developed while Oracle 9i was the current database release, it has long been speculated that this exam would retire. As of the announcement, the exam will no longer be available after July 31, 2013. Oracle professionals pursuing the PL / SQL development path have asked what effect this retirement will have on the process of obtaining the PL / SQL OCA certification. The impact of the announcement and what actions to take depend on the stage of the PL / SQL certification process you are in.
- If you passed 1Z0-147 – For people who have already passed the test, the retired exam means absolutely nothing. Oracle certifications and exam results do not change when an exam is ended. The only people affected by the retirement are those who have not yet taken it. It is no longer possible to schedule the exam after the closing date.
- If you are currently preparing for 1Z0-147 – If you are currently studying for this exam and are almost ready to take it, you need to complete your preparation and schedule the exam. Don’t wait until the last minute. You want to have enough time to do it again if you don’t pass the first attempt. Once the deadline has passed, you cannot schedule the exam for any reason. If you are preparing for the exam but have just started, consider the following option.
- If you haven’t started preparing yet – If you intend to take the 1Z0-147 exam but have not started preparation at this time, I recommend that you take the replacement exam, 1Z0-144: Oracle Database 11g: program with PL / SQL. The two exams serve the same purpose and if you pass in combination with an SQL exam you will get the PL / SQL OCA. The 1Z0-144 exam won’t retire for years, so you’ll have plenty of time to prepare for it.
1Z0-147 and 1Z0-144 have a significant percentage of common topics. 1Z0-144, however, has been significantly rewritten. The exam includes new features added to the PL / SQL engine in Oracle 10G and 11G. However, the exam also added a significant number of topics for core PL / SQL skills. Most of these should demonstrably be included as part of 1Z0-147. I have thoroughly examined both tests and I am convinced that 1Z0-144 is by far the best of the two. The retirement of 1Z0-147 was a long time ago.