For Oracle industry experts who are pursuing the Oracle PL/SQL Developer Accredited Affiliate certification, there are two tests that will fulfill the PL/SQL necessity: “1Z0-147: Plan with PL/SQL” and the newer version: “1Z0-144: Oracle Database 11g: System with PL/SQL”. There is a good amount of confusion between candidates trying to get certification over irrespective of whether they should consider 1 examination, or the other, or both. The intent of this article is to help make clear the two assessments, their similarities and variations, and why you may well choose a person in excess of the other.
A single issue should be manufactured clear from the outset: there is hardly ever a explanation to take each checks. Compared with the DBA keep track of, Oracle PL/SQL certifications are not tied to the databases release. You do not grow to be accredited in launch X of Oracle PL/SQL and then have a prerequisite to acquire improve exams. Because either of these two assessments will satisfy the OCA-level PL/SQL prerequisite, passing the other would supply no certification advantage. That claimed, you will have to come to a decision which of the two tests to go after. The 1Z0-147 examination is various years older than 1Z0-144. Except if there is a unique cause that getting the older exam will profit you, your far better solution is to go with the 11G variation of the exam. Right until Oracle retires 1Z0-147, on the other hand, the selection is yours.
The two checks have a fantastic offer of commonality involving them. This makes perception as they are for fundamentally the exact same topic. What is shocking is the number of discrepancies that exist concerning the two. 1Z0-144 is not basically a remake of the previously examination with new PL/SQL options from versions 10G and 11G tacked on. There is an totally diverse sense to the check and the topics protected. There are several sections that do not exist in 1Z0-147 which address functions that did not exist in 9i. However, the bulk of the new sections in 1Z0-144 cover core subject areas of PL/SQL programming that arguably really should have been in the before check. Some of the styles of info coated in 1Z0-144 but not 1Z0-147 include things like:
- The advantages of employing PL/SQL
- Programming basics, which includes variables, conventions, characteristics, and lexical models
- Use of SQL features in PL/SQL
- Implicit vs. explicit facts conversion
- Use of labels, indentation, and whitespace to make more readable code
- The use of DML in PL/SQL
- The use of handle constructions and Loops
- The use of cursors and cursor characteristics
- The use of the FOR UPDATE clause
- Exception Handling
- PL/SQL Design factors
- Composite knowledge varieties
- Autonomous transactions
- BULK SQL operations
- PL/SQL compiler variations
The amount of subject areas covered in 1Z0-147 that are not protected in 1Z0-144 is a lot more compact. Nevertheless, the to start with a few are surprising looking at the pronounced change to PL/SQL fundamentals in the 11G examination:
- Privileges required to execute strategies
- Parameter modes and DEFAULT values
- Parameter passing strategies — by reference vs. by value
- A significantly more substantial focus on triggers
- A lot more references to client-side PL/SQL (1Z0-144 mostly ignores shopper-aspect)
- More target on PL/SQL dependencies and invalidations
- Large objects and the use of the DBMS_LOB bundle
If you close up pursuing 1Z0-147, be guaranteed to review working with the Oracle 9i documentation. Capabilities that were extra to PL/SQL in 10G or 11G will not be on that exam. Obtaining researched the topics for equally exams, I consider 1Z0-144 to be the improved test from the standpoint of the details examined. The subject matter make any difference is a improved blend of what is vital for an entry-amount PL/SQL developer to know. New builders learning for this exam will arrive out with a additional rounded and entire awareness of PL/SQL fundamentals. Whichever test you pursue, be guaranteed to study each individual of the examination subjects listed on the Oracle Education and learning website in advance of scheduling the examination. Excellent luck on the test.